DatabasePlanet PostgreSQL
Database
Debugging PostgreSQL connections requires stopping a backend before it does anything interesting. (I consult on PostgreSQL through PGX Inc..)
Somewhere in the multiverse, there is a version of you who attends every interesting talk at PGConf.EU. Unfortunately, in this universe, PostgreSQL has parallel query execution. Humans don’t. Last year, I created an Underground Map for…
pg_vectorsearch is a new open-source Postgres extension. Its PRISM index serves 100M vectors in 6 ms on 4x less RAM than HNSW, with builds in under 2 hours.
This is part 3 of a series about Postgres logical replication use-cases, and about how the feature set has evolved over the past ten years and ten releases (Postgres 10 through the Postgres 19 beta), one architecture at a time. Part 1…