DatabasesPlanet PostgreSQL
Databases
The `port` parameter does double duty: it names the TCP socket and the Unix socket file too. (I consult on PostgreSQL through PGX Inc..)
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.