Public list by ~postgresweekly
https://www.snowflake.com/en/blog/engineering/postgresql-19-features-beta/
Looking Ahead to Postgres 19 â âPostgres 19 feels like one of those releases that has a bit of everything,â says Craig, who focuses on quality of life improvements that day-to-day Postgres users will come to appreciate, both at the operational level (e.g. REPACK and partitioning improvements) and in SQL (e.g. SQL/PGQ and GROUP BYÂ ALL).
about 2 months ago
https://aka.ms/posette-playlist
44 Recorded PostgreSQL Talks Are Now Available to Watch â POSETTE: An Event for Postgres 2026 is over, but the talks are here to stay. All sessions are now available on YouTube, so you can learn directly from Postgres experts at your own pace. Access the full playlist of 44 talks.
about 2 months ago
https://www.youtube.com/watch?v=ppGO7r2sEkE
â¶Â  What's Missing in Postgres? â We report on features Postgres is adding all the time, but whatâs âmissingâ and why? Bruce touches on a diverse range from sharding and connection pooling to columnar storage and transparent data encryption. Canât watch? Here are the slides in PDF form.
about 2 months ago
https://aws.amazon.com/blogs/database/postgresql-18-on-amazon-aurora-and-amazon-rds-performance-enhancements/
Postgres 18 Performance Enhancements â Postgres 18 has many enhancements and performance tweaks worth reviewing. This tour covers skip scan optimization, Self-Join Elimination, autovacuum settings, and more. It takes an AWS perspective, but most of it applies to anyone on Postgres 18.
about 2 months ago
https://richyen.com/postgres/2026/06/22/pg_stats_how_postgres_internal_stats_work.html
pg_stats: How Postgres Internal Stats Work â Get a working understanding of what pg_stats is, and how it shapes the query planner's decisions.
about 2 months ago
https://www.pghardstorage.org/
pg_hardstorage 1.0: A New Backup and Recovery Approach â A streaming-first, host-access-free, chain-free backup tool in a single binary that streams the WAL over an ordinary replication connection for gap-free, byte-precise PITR. It includes pgBackRest and Barman shims so you can swap it in/try it out without rewriting your automation.
about 2 months ago
https://a-saed.github.io/datum/
đ Datum: Local-First Spatial Syncing for PostGIS â A local-first sync layer that mirrors Postgres/PostGIS tables into an in-browser PostGIS instance (via the WASM-based PGlite) with real-time deltas over NOTIFY.
about 2 months ago
https://migration.useautopilot.dev/
Migration Autopilot: GitHub Action to Review DB Migration PRs â Looks at database migrations and detects the renaming or dropping of columns and tables, truncation, and similar issues.
about 2 months ago