At first glance, storing and querying embeddings in PostgreSQL may seem impractical—but with the right setup, it’s both efficient and effective. This post covers how to design your schema, store vectors properly, and perform fast similarity searches without the usual headaches.
Embeddings are the foundation of vector search, allowing us to represent meaning-rich content like documents or queries as numerical vectors. But to use them effectively, it’s essential to understand what’s actually being embedded—whether that’s individual words, full sentences, or larger chunks of text.
As vector search becomes a foundational feature in modern applications—from semantic search and recommendation engines to AI-driven insights—developers are increasingly adopting PostgreSQL with the pgvector extension. However, one concept often creates confusion: the difference between similarity and distance.
At PGConf India 2025, I shared strategies for upgrading PostgreSQL replication clusters with no disruption to operations—highlighting examples and the evolving capabilities of logical replication.
For many organizations, the race to adopt AI is already underway. But too often, projects stall, not because of the models, but because the data underneath them is chaotic, inconsistent, or poorly understood.
A recent cryptomining attack on PostgreSQL servers revealed how misconfigurations and weak credentials can be exploited to deploy fileless malware, underscoring the need for proactive, layered security measures to defend against evolving threats. Nishchay Kothari explains.
It was an exciting experience to share the stage with my Fujitsu coleague Nishchay Kothari PGConf.dev 2025 to present our session on the topic of Learned Indexes in PostgreSQL. For those that could not attend, we would like to share our presentation.
Earlier this year, I had the pleasure of speaking at PGConf India 2025, where I presented on one of the most exciting advancements in PostgreSQL 17—how logical replication is now more resilient and failover-ready with failover logical slots—and today, I’m excited to share the slides from that talk with you.
In an era where fraudsters continually evolve their tactics, ensuring your fraud detection architecture is resilient and adaptable isn't just beneficial—it's essential. Discover how Fujitsu Enterprise Postgres 17 SP1 equips you with the tools to stay ahead.
Earlier this year, I had the incredible opportunity to present at PGConf India, where I delved into the intricacies of Write-Ahead Logging (WAL) in PostgreSQL. My presentation aimed to demystify this crucial database feature that ensures data integrity and enhances performance.
In today’s cloud-native world, security isn’t just a checkbox — it’s foundational. When managing business-critical workloads like databases in Kubernetes, particularly with robust platforms such as Fujitsu Enterprise Postgres, ensuring secure access to sensitive information like credentials and TLS certificates is a must. This is where HashiCorp Vault comes into play.
Fujitsu has released Fujitsu Enterprise Postgres 17 SP1, with the aim of providing a secure and user-friendly data infrastructure for AI applications. There are a lot of exciting capabilities added, let me take your through them.
Fujitsu has participated in the PostgreSQL community for over 20 years and has contributed to PostgreSQL development by developing new features, as well as creating and reviewing correction patches. And last year we took our team contributions to a whole new level.
PGConf-India 2025 was amazing—a hub of innovation, collaboration, and deep technical discussions! This year, the conference welcomed participants from 80+ cities across 20+ countries, bringing together some of the brightest minds in the PostgreSQL world.
The public sector is undergoing a digital transformation, and at the heart of this shift lies a powerful enabler: open source technology. Once seen primarily as a tool for startups and tech giants, open source is now becoming the cornerstone of government modernization efforts around the globe.
