What r/PostgreSQL is talking about this week

Moving my project from MS Sql to PostrgesSql, Need to run mass update query, ClientDelivery table has 1,054,155 records In MsSql query takes about 10 seconds, In PostgresSql it actually never...

For anyone interested in BM25 search and especially legal opinion search, Greg Burd has been very active developing pg\fts https://github.com/gburd/pg\fts a PostgreSQL extension for full-text...

I recently recorded a Talking Postgres episode with Magnus Hagander, a Postgres committer, core team member, and longtime PGConf EU organizer, about how he got started in Postgres. A few things we...

WalShadow replicates data from Postgres to ClickHouse via physical WAL, and not logical replication. This blog talks about the latency, handling of restarts, stops etc., and issues encountered...

Hello, I’ve inherited a data lake that is all done in postgres. I’ve done a little bit of DBA stuff in the past, but it was all SQL or Oracle. Any recommendations on training to learn how to pull...

I've been experimenting with PostgreSQL 18 tuning for memory-constrained VPS deployments, particularly where the database needs to leave enough RAM for a small application. I wanted to compare two...

In the age of AI I think personal connections are even more important than before. That's why I try to help promoting events where people can meet in-person or virtually and discuss the topics...