Postgres FM

View Top 200 Chart

Back to Rankings Page

Technology
**Postgres FM**

A weekly podcast about all things PostgreSQL

Latest Episodes:

PostgREST Dec 02, 2022

Show notes

Here are links to a few things we mentioned:

PostgREST documentation
Supabase
No offset (blog post by Markus Winand)
JSON functions and operators (PostgreSQL docs)
Stored procedures (a previous Postgres FM episode)
PostGraphile
Hasura
Parse, Inc.
Firebase
PostgresML
PgQ

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

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

Materialized views Nov 25, 2022

Show notes

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

HOT updates Nov 18, 2022

Show notes

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

Database branching Nov 11, 2022

Show notes

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

Version control for databases Nov 04, 2022

Show notes

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

Contributing to Postgres Oct 28, 2022

Show notes

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

Stored procedures Oct 21, 2022

Show notes

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

PostgreSQL 15 Oct 14, 2022

Show notes

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

102 Query optimization Oct 07, 2022

Show notes

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

Why is Postgres popular? Sep 30, 2022

Show notes

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: