
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…

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…
`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..)
PostgreSQL and NUMA, Part 4 of 4 This series covers the specifics of running PostgreSQL on large systems with many processors. My experience is that people spend months often learning the basics when confronted with the problem. This…