Public list by ~postgresweekly
https://github.com/achristmascarl/rainfrog
Rainfrog 0.4: A Database Management TUI for Postgres â Think a little more structured than psql with vim-style navigation of queries, history, schemas, etc. v0.4 adds query autocompletion.
22 days ago
https://planetscale.com/blog/whats-new-in-postgres-19
Three New Things in Postgres 19 â PlanetScale takes its turn to reflect on the upcoming release, focusing on REPACK, JIT being off by default, and query planner improvements.
22 days ago
https://nikolays.github.io/PGSimCity/
PGSimCity: How Postgres Works, in 3D â A truly novel way to explore a model of Postgres internals. It's more than a visualization, you can wander around and break stuff! It's a little 'busy' and not perfect UX-wise (you might struggle on mobile devices) but offers a fresh perspective on some otherwise opaque technical concepts.
22 days ago
https://www.pgedge.com/blog/looking-forward-to-postgres-19-autovacuum-tweaks
Autovacuum Tweaks Coming to Postgres 19 â Autovacuum has always worked through tables in catalog order, but Postgres 19 teaches it to triage with tables scored on factors like wraparound risk and dead tuples, so the most deserving cases get tackled first.
22 days ago
https://boringsql.com/posts/mvcc-bad-bad/
Postgres's MVCC is Bad, But So is Everyone Else's â Andy Pavlo's database group called MVCC the part of Postgres they hate the most, and Radim agrees, with benchmarks. But then he asks: what do Oracle, InnoDB, SQL Server, MongoDB and etcd do instead, and what does that cost?
22 days ago
https://hatchet.run/blog/postgres-survival-guide
The Startup's Postgres Survival Guide â A startup has opened up its internal guide distilling two years of Postgres battles, from schema rules and compound indexes to autovacuum tuning, SKIP LOCKED queues and partitioning.
22 days ago
https://stormatics.tech/blogs/the-right-way-to-give-a-third-party-dba-access-to-your-postgresql-database
The Right Way to Give a Third-Party DBA Access to Your Database â From the basics of creating a scoped role to providing safe access to monitoring, being able to cancel runaway queries, and even vacuuming and reindexing, without handing over ownership or superuser access.
22 days ago
https://danolivo.substack.com/p/why-your-pioneering-postgres-feature
Why Your Pioneering Postgres Feature Should Start in a Fork â A Postgres planner contributor on his three attempts at parallel scans over temporary tables, undone by local buffers and read-only queries that dirty pages anyway. A fork was the place to prove it, he says, because core's 'bar is brutal'.
22 days ago
https://github.com/devrimgunduz/pagila
Pagila 4: A Sample Database for Postgres â Originally a port of MySQL's Sakila example database, Pagila has been extended to support numerous Postgres-specific functions (like SQL/JSON and UUIDv7) and v4.0 (which requires Postgres 18) is much larger with a more diverse dataset.
22 days ago
https://github.com/Evokoa/pgGraph/releases/tag/v1.0.0
pgGraph 1.0: Add Graph Database 'Superpowers' to Postgres â An extension that brings the ability to run graph search, traversal, shortest path, and relationship queries directly against ordinary tables.
22 days ago
https://paradedb.com/
Search Without a Second System â One Postgres for your application data, full-text search, vector retrieval, and aggregations. ParadeDB is an open-source Postgres extension that keeps pace with Elasticsearch.
about 1 month ago