As applications grow, database teams need to make increasingly complex decisions about how to distribute data, manage workloads, and scale their infrastructure. Sharding enables MongoDB to scale horizontally, but managing a sharded cluster…
My last post leaned hard on the DB-Engines ranking, and I admitted that ranking measures popularity, not installed base or revenue. Several of you called me on that, politely and otherwise. Fair enough. So this time I went looking for…

Tiger Data has released pg_vectorsearch, an open source PostgreSQL extension for vector similarity search, currently in alpha. Its PRISM index uses data partitioning and compression instead of the graph-based approach used by pgvector’s…
`scram_iterations` embeds itself in each password when set and stays there forever, making it a per-password property masquerading as a server setting. (I consult on PostgreSQL through PGX Inc..)