Postgres FM

Nik and Michael are joined by Shaun Thomas to discuss estimating work_mem, memory management in general, and writing an extension to help.
 
Here are some links to things they mentioned: 
Shaun Thomas https://postgres.fm/people/shaun-thomas
work_mem https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-WORK-MEM
pg_stat_database https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-DATABASE-VIEW
ALTER ROLE SET configuration_parameter https://www.postgresql.org/docs/current/sql-alterrole.html#SQL-ALTERROLE-PARAMS-CONFIGURATION-PARAMETER
hash_mem_multiplier https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-HASH-MEM-MULTIPLIER
Recent Postgres releases with 28 CVEs fixed https://www.postgresql.org/about/news/postgresql-186-1711-1615-1519-1424-and-19-beta-3-released-3365/
Systemic Risks in the Managed PostgreSQL Industry (part 1 of 6, Mehmet Ince) https://mehmetince.net/part-1-6-systemic-risks-in-the-managed-postgresql-industry-extension-risks-are-real-exploiting-postgis-memory-corruption-bug-at-neondb-supabase-and-many-more/
Improving Postgres Connection Scalability: Snapshots (blog post by Andres Freund) https://techcommunity.microsoft.com/blog/adforpostgresql/improving-postgres-connection-scalability-snapshots/1806462

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~
Postgres FM is produced by:
Michael Christofides, founder of pgMustard
Nikolay Samokhvalov, founder of Postgres.ai

With credit to:
Jessie Draws for the elephant artwork

Nik and Michael are joined by Michael Malis, co-creator of pgrust, to discuss their Postgres rewrite, including reliability problems, compatibility testing, faster analytics, and a new JIT-compiled query engine.
 
Here are some links to things they mentioned: 
Michael Malis https://postgres.fm/people/michael-malis
pgrust https://github.com/malisper/pgrust 
The four horsemen behind Postgres outages (blog post by Michael Malis) https://malisper.me/the-four-horsemen-behind-thousands-of-postgres-outages
Rebuilding Postgres for faster analytics: batching, operator fusion, and SIMD (blog post by Michael Malis) https://malisper.me/how-we-made-postgres-hundreds-of-times-faster-the-query-engine/
kani https://github.com/model-checking/kani
Antithesis https://antithesis.com
fsyncgate mailing list thread https://www.postgresql.org/message-id/flat/CAMsr%2BYHh%2B5Oq4xziwwoEfhoTZgr07vdGG%2Bhu%3D1adXx59aTeaoQ%40mail.gmail.com
How AI Changes the Economics of JIT Compilers (blog post by Michael Malis) https://malisper.me/how-ai-changes-the-economics-of-jit-compilers/
Umbra DB https://umbra-db.com

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~
Postgres FM is produced by:
Michael Christofides, founder of pgMustard
Nikolay Samokhvalov, founder of Postgres.ai

With credit to:
Jessie Draws for the elephant artwork

Nik and Michael are joined by Radim Marek to discuss MVCC, including his recent article on how Postgres chose to implement it compared to other systems.
 
Here are some links to things they mentioned: 
Radim Marek https://postgres.fm/people/radim-marek
BoringSQL https://boringsql.com
PostgreSQL's MVCC is bad. So is everyone else's (blog post by Radim) https://boringsql.com/posts/mvcc-bad-bad/
PostgreSQL MVCC documentation https://www.postgresql.org/docs/current/mvcc-intro.html
PostgreSQL Storage Internals series by Radim https://boringsql.com/guides/postgresql-storage-internals/
PgQue https://github.com/NikolayS/pgque
The next ten years of Postgres (talk slides by Álvaro Herrera) https://www.postgresql.eu/events/pgconfde2026/sessions/session/7744/slides/866/edb-keynote-pgconfde-2026.pdf
Episode on RegreSQL https://postgres.fm/episodes/regresql
DryRun MCP https://github.com/boringsql/dryrun

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~
Postgres FM is produced by:
Michael Christofides, founder of pgMustard
Nikolay Samokhvalov, founder of Postgres.ai

With credit to:
Jessie Draws for the elephant artwork

Nik and Michael are joined by Tudor Golubenco, CTO of Xata, to discuss their architecture, progress, and open source tooling.
 
Here are some links to things they mentioned: 
Tudor Golubenco https://postgres.fm/people/tudor-golubenco
Xata https://xata.io
Xata is now open source https://xata.io/blog/xata-is-now-open-source
DBLab Engine https://postgres.ai/docs/database-lab
pgstream https://github.com/xataio/pgstream
Xata acquires Privacy Dynamics for advanced anonymization https://xata.io/blog/xata-acquires-privacy-dynamics
Tonic AI https://www.tonic.ai
A thousand Postgres branches for one dollar https://xata.io/blog/a-thousand-postgres-branches-for-1
pgroll https://github.com/xataio/pgroll
CloudNativePG https://github.com/cloudnative-pg/cloudnative-pg
PGSimCity https://nikolays.github.io/PGSimCity
DeltaX https://github.com/xataio/deltax

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~
Postgres FM is produced by:
Michael Christofides, founder of pgMustard
Nikolay Samokhvalov, founder of Postgres.ai

With credit to:
Jessie Draws for the elephant artwork

Nik and Michael are joined by Qian Li and Peter Kraft to talk about DBOS, an open source platform for durable workflows built on Postgres. 
 
Here are some links to things they mentioned: 
Qian Li https://postgres.fm/people/qian-li
Peter Kraft https://postgres.fm/people/peter-kraft
DBOS https://www.dbos.dev
Temporal https://temporal.io
Gadget's use of Postgres https://postgres.fm/episodes/gadgets-use-of-postgres
Postgres LISTEN/NOTIFY blog post from Recall AI https://www.recall.ai/blog/postgres-listen-notify-does-not-scale
Postgres 19 commit that improves LISTEN/NOTIFY, avoiding waking backends that have no need to process the notification messages https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=282b1cde9
 PgQue https://github.com/NikolayS/pgque
pg_durable https://github.com/microsoft/pg_durable
Absurd https://github.com/earendil-works/absurd
LISTEN/NOTIFY performance considerations (docs patch submitted by Nik) https://www.postgresql.org/message-id/flat/CAM527d8oDVb2K%2BtTjpjLkd7g14HLDiwwnvv%3Drcn4BMEs%3DMatkQ%40mail.gmail.com#1b6fa752a96aad22bd8ef794fbaf3ea1

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~
Postgres FM is produced by:
Michael Christofides, founder of pgMustard
Nikolay Samokhvalov, founder of Postgres.ai

With credit to:
Jessie Draws for the elephant artwork