Public list by ~postgresweekly
https://github.com/a24films/puffgres
Puffgres: Keep Postgres Entities Synced with Turbopuffer — Ever heard of A24, the distributor of movies like Backrooms and Uncut Gems? Their first open source release is a Rust tool that uses logical replication to mirror Postgres entities to Turbopuffer, the cloud vector/full-text search service.
29 days ago
https://planetscale.com/blog/making-768-servers-look-like-1
Making 768 Servers Look Like 1 — A fun, educational animated explainer of how a petabyte of Postgres spread over 256 shards (each with a primary and two replicas) can present as one database, covering where replicas hit a wall, query-parsing routers, and load balancing.
29 days ago
https://incident.io/blog/dont-add-a-read-replica-until-youve-read-this
Don't Add a Read Replica Until You've Read This — A common issue with read replicas is stale reads, which can surface in unexpected places. incident.io explains the approach they used while moving most of their reads off their primary, including LSN stamping and query routing strategies.
29 days ago
https://www.crunchydata.com/blog/postgres-19-compression-from-pglz-to-lz4
Postgres 19 Compression: From pglz to LZ4 — In v19, TOAST compression switches by default from pglz to LZ4 (an option since Postgres 14). Christopher covers the history, but also the fun stuff: the decision tree for what gets compressed or TOASTed, and how indexes compress oversized keys.
29 days ago
https://turso.tech/blog/a-new-modern-version-of-postgres-in-rust
Turso: 'We're Building Postgres in Rust' — We've recently featured pgrust but now Turso, known for rewriting SQLite in Rust, is having a go too with an LLVM-inspired approach: a single database core that presents via multiple frontends, of which Postgres is the second.
29 days ago
https://talkingpostgres.com/episodes/working-on-postgres-after-13-years-on-sql-server-with-panagiotis-antonopoulos
▶  Working on Postgres After 13 Years on SQL Server — Microsoft's Panagiotis Antonopoulos discusses his transition from 13 years on SQL Server to Postgres, why Postgres has become the default choice for many workloads, and Azure HorizonDB's shared-storage architecture.
29 days ago
https://pgbackrest.org/news.html#release-2-59-0
pgBackRest 2.59.0 Released with Postgres 19 Support — The first release of the popular backup and restore tool since the project briefly died and came back to life. Getting ready for Postgres 19 is the focus, but some handy S3 and Azure enhancements have been added too.
29 days ago
https://github.com/cybertec-postgresql/pg_timetable
pg_timetable 7.0: Advanced Job Scheduling for Postgres — A mature, stand-alone job scheduler that stores its state in your database and lets you schedule tasks and chain them together. v7 adds OpenTelemetry tracing, arm64 support to the Docker image, and a way to enable/disable tasks.
29 days ago
https://www.tigerdata.com/go/trial
REFRESH MATERIALIZED VIEW Shouldn't Block Prod — You wrote the materialized view to pre-compute rollups. Now it locks the table on refresh. Get $1000 in credit to try what replaces it. TimescaleDB continuous aggregates update incrementally on live data. No REFRESH, no lock, no cron.
3 months ago