Postgres FM

Apologies, Michael's audio is not great in this, we'll hopefully be back to normal next week!

Here are links to a few things we mentioned: 

• Materialized views (docs)
• Refresh materialized view (docs)
• Timescale blog post
• PlanetScale Boost (content warning: MySQL) 
• Incremental Materialized Views with pg_ivm (video by Lukas Fittl) 
• Articles on how to do your own incremental updates(?)
• Materialize (company) 
• Materialize talk
• Incremental View Maintenance (Postgres wiki)  
• Implementing Incremental View Maintenance (mailing list thread) 

------------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork 

Here are links to a few things we mentioned: 

• Heap-only tuple updates (docs)
• README file (source code)
• Heap Only Tuple chapter (Internals of PostgreSQL by Hironobu SUZUKI) 
• How partial, covering, and multicolumn indexes may slow down UPDATEs (blog post by Nikolay) 
• Why Uber switched from Postgres to MySQL (blog post)  
• Fighting write amplification with HOT updates (Adyen blog post) 
• HOT Updates vs Bottom-Up Index Deletion (video by Lukas Fittl from pganalyze) 
• Reduced Bloat with Bottom-Up Deletion (blog post by Hamid Akthar from Percona) 
• What is fillfactor and how does it affect performance? (blog post by Kaarel Moppel from Cybertec)

------------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork 

Here are links to a few things we mentioned: 

• Database Lab Engine
• Overview of Aurora cloning 
• PlanetScale branching
• Common DB schema change mistakes (blog post by Nikolay)
• Supabase vision
• Neon branching
• Shift-left testing

------------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork 

Here are links to a few things we mentioned: 

• A brief history of Version Control Systems (blog post by Mehran Hajirajabi)
• Redgate Source Control for Oracle (and SQL Server)
• Flyway 
• Sqitch 
• Liquibase 
• pgAdmin Schema Diff 
• Migra 
• PostgresCompare 
• Schema based versioning and deployment (blog post by Valentine Gogichashvili)
• Change management tools and techniques (PostgreSQL Wiki)
• GitLab migration_helpers.rb 
• Database schema changes without downtime (blog post by James Coleman from Braintree/PayPal) 
• Zero-downtime Postgres schema migrations need lock_timeout and retries (blog post by Nikolay) 

------------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork 

Here are links to a few things we mentioned: 

• PostgreSQL 14 coin (upside down!)
• Intro to Planner Hacking (talk by Melanie Plageman)
• Demystifying contributing to PostgreSQL (talk by Lætitia Avrot)
• How to become a PostgreSQL contributor (blog post by Aleksander Alekseev)
• Compile and install from source code (PostgreSQL Wiki)
• PostgreSQL mailing lists
• GitHub PostgreSQL mirror
• GitLab PostgreSQL mirror
• Commitfests
• So, you want to be a developer? (PostgreSQL Wiki)
• Resolving the search engine issue (mailing list thread)
• Planet PostgreSQL
• pg_stat_monitor (extension by Percona)
• ZomboDB
• pgx (framework for developing extensions)
• Awesome Postgres
• Depesz blog 

------------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork 

Here are links to a few things we mentioned: 

• Extending SQL 
• PostgREST  
• PL/pgSQL 
• EdgeDB  
• pgTAP  
• Sqitch 
• Flyway  
• Liquibase  
• client_min_messages  
• log_min_messages
• RAISE DEBUG
• Simplify: move code into database functions (blog post by Derek Sivers)  
• PL/sh  
• Supabase 
• auto_explain.log_nested_statements  
• Hasura  

------------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork 

Here are links to a few things we mentioned: 

• PostgreSQL 15 release notes
• Speeding up sort performance in Postgres 15 (blog post by David Rowley)
• Past, Present, and Future of Logical Replication (talk by Amit Kapila) 
• Postgres 15 improves UNIQUE and NULL (blog post by Ryan Lambert) 
• Do you vacuum everyday? (talk by Hannu Krosing) 
• Why upgrade PostgreSQL? (by depesz)

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @PostgresFM or by commenting on our topic ideas Google doc.

If you would like to share this episode, here's a good link (and thank you!)

------------------------

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork 

Here are links to a few things we mentioned: 

• pg_plan_advsr 
• How partial, covering, and multicolumn indexes may slow down UPDATEs (blog post by Nikolay)
• Why Uber Switched from Postgres to MySQL (blog post)
• pganalyze index advisor
• Nancy bot (project is not active)
• pgreplay
• pgreplay go  
• Real Application Testing on YugabyteDB with pgreplay (blog post by Franck Pachot) 
• pg_query  
• Database Lab thin clones 
• Migrating to Aurora: easy except the bill (blog post by Kimberley Nicholls) 

------------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @PostgresFM or by commenting on our topic ideas Google doc.

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork 

This episode was badly affected by internet issues. Hopefully the edit came out ok, but the quality should be back to a better level from next week.

Here are links to a few things we mentioned: 

• Monthly blog event, PGSQL Phriday (blog post from Ryan Booz) 
• Who or what made Postgres cool? (tweet from Kenneth Cassel) 
• PostGIS 
• Acquisition of Sun by Oracle 
• DB-Engines trend
• Hacker News hiring trends 
• Supabase on GitHub (nearly 40k stars)
• How I Built This (podcast) 

------------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @PostgresFM or by commenting on our topic ideas Google doc.

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork 

Important correction from this episode: amcheck promises no false positives, not no false negatives, sorry!

Here are links to a few things we mentioned: 

• pgstattuple
• pg_repack
• postgres-checkup 
• Workload Analysis for GitLab.com
• Bloat Analysis (also from GitLab)
• Bloat, pg_repack, and deferred constraints (blog post by Miro) 
• amcheck
• Peter Geoghegan interview (on Postgres TV) 

------------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our topic ideas Google doc.

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the elephant artwork