Postgres FM

Nik and Michael discuss query level comments, object level comments, and another way of adding object level metadata.
 
Here are some links to things they mentioned: 
Object comments https://www.postgresql.org/docs/current/sql-comment.html
Query comment syntax (from an old version of the docs) https://www.postgresql.org/docs/7.0/syntax519.htm
SQL Comments, Please! (Post by Markus Winand) https://modern-sql.com/caniuse/comments
“While C-style block comments are passed to the server for processing and removal, SQL-standard comments are removed by psql.” https://www.postgresql.org/docs/current/app-psql.html
marginalia https://github.com/basecamp/marginalia
track_activity_query_size https://www.postgresql.org/docs/current/runtime-config-statistics.html#GUC-TRACK-ACTIVITY-QUERY-SIZE
Custom Properties for Database Objects Using SECURITY LABELS (post by Andrei Lepikhov) https://www.pgedge.com/blog/custom-properties-for-postgresql-database-objects-without-core-patches

~~~
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 Lev Kokotov for an update on all things PgDog.
 
Here are some links to things they mentioned:
Lev Kokotov https://postgres.fm/people/lev-kokotov
PgDog https://github.com/pgdogdev/pgdog
Our first PgDog episode (March 2025) https://postgres.fm/episodes/pgdog
Sharding pgvector (blog post by Lev) https://pgdog.dev/blog/sharding-pgvector
Prepared statements and partitioned table lock explosion (series by Nik) https://postgres.ai/blog/20251028-postgres-marathon-2-009

~~~
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 from boringSQL to talk about RegreSQL, a regression testing tool for SQL queries they forked and improved recently.
 
Here are some links to things they mentioned:
Radim Marek https://postgres.fm/people/radim-marek
boringSQL https://boringsql.com
RegreSQL: Regression Testing for PostgreSQL Queries (blog post by Radim) https://boringsql.com/posts/regresql-testing-queries
Discussion on Hacker News https://news.ycombinator.com/item?id=45924619 
Radim’s fork of RegreSQL on GitHub https://github.com/boringSQL/regresql 
Original RegreSQL on GitHub (by Dimitri Fontaine) https://github.com/dimitri/regresql 
The Art of PostgreSQL (book) https://theartofpostgresql.com
How to make the non-production Postgres planner behave like in production (how-to post by Nik) https://postgres.ai/docs/postgres-howtos/performance-optimization/query-tuning/how-to-imitate-production-planner 
Just because you’re getting an index scan, doesn't mean you can’t do better! (Blog post by Michael) https://www.pgmustard.com/blog/index-scan-doesnt-mean-its-fast
boringSQL Labs https://labs.boringsql.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 discuss the events and trends they thought were most important in the Postgres ecosystem in 2025.
 
Here are some links to things they mentioned: 
Postgres 18 release notes https://www.postgresql.org/docs/18/release-18.html
Our episode on Postgres 18 https://postgres.fm/episodes/postgres-18
LWLock:LockManager benchmarks for Postgres 18 (blog post by Nik) https://postgres.ai/blog/20251009-postgres-marathon-2-005
PostgreSQL bug tied to zero-day attack on US Treasury https://www.theregister.com/2025/02/14/postgresql_bug_treasury
PgDog episode https://postgres.fm/episodes/pgdog
Multigres episode https://postgres.fm/episodes/multigres
Neki announcement https://planetscale.com/blog/announcing-neki
Our 100TB episode from 2024 https://postgres.fm/episodes/to-100tb-and-beyond
PlanetScale for Postgres https://planetscale.com/blog/planetscale-for-postgres
Oracle's MySQL job cuts https://www.theregister.com/2025/09/11/oracle_slammed_for_mysql_job
Amazon Aurora DSQL is now generally available https://aws.amazon.com/about-aws/whats-new/2025/05/amazon-aurora-dsql-generally-available
Announcing Azure HorizonDB https://techcommunity.microsoft.com/blog/adforpostgresql/announcing-azure-horizondb/4469710
Lessons from Replit and Tiger Data on Storage for Agentic Experimentation https://www.tigerdata.com/blog/lessons-replit-tiger-data-storage-agentic-experimentation
Instant database clones with PostgreSQL 18 https://boringsql.com/posts/instant-database-clones
turbopuffer episode https://postgres.fm/episodes/turbopuffer
Crunchy joins Snowflake https://www.crunchydata.com/blog/crunchy-data-joins-snowflake
Neon joins Databricks https://neon.com/blog/neon-and-databricks

~~~
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 discuss a listener question about archiving a database.
 
Here are some links to things they mentioned: 
Listener request to talk about archiving https://www.youtube.com/watch?v=KFRK8PiIvTg&lc=UgyiFrO37gEgUaVhRgN4AaABAg 
Our episode on “Is pg_dump a backup tool?” https://postgres.fm/episodes/is-pg_dump-a-backup-tool 

~~~
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