Postgres FM

Here are links to a few things we mentioned: Database Lab EngineOverview of Aurora cloning PlanetScale branchingCommon DB schema change mistakes (blog post by Nikolay)Supabase visionNeon branchingShift-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.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the amazing artwork 

This podcast explores the importance of version control for databases, including the challenges of schema change management. The hosts discuss Postgres Compare, the significance of including data in the schema, and the difficulties of managing create statements in version control. They also explore the concept of separating tables and functions, the challenges of triggers and table alteration locking attempts, and the difficulties of managing configuration files in version control.

Discover the myriad ways to contribute to the Postgres community, from coding to knowledge sharing. Explore the significance of non-coding contributions, including translations and content creation that enhance user experience. Learn about the critical role of documentation and the need for visual guides. Delve into exciting extensions like ZomboDB that connect Postgres with Elasticsearch. Finally, understand how community support enriches the ecosystem for both newcomers and seasoned contributors, fostering a collaborative spirit.

The podcast explores the benefits of using stored procedures in a database, such as data consistency and improved performance. It also discusses the advantages of using Rails or Django for database management and the challenges of working with views and functions in PostgreSQL. The chapter delves into scaling strategies, subtransactions in POSGIS, and the use of stored procedures in database development. Overall, the speakers emphasize the importance of version control, testing, and the potential impact of projects like Superbase and Hasura.

Here are links to a few things we mentioned: PostgreSQL 15 release notesSpeeding 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.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the amazing artwork 

The podcast discusses query optimization in PostgreSQL, including steps involved, testing in a similar setup as production, analyzing the impact of sampling and bloat, optimizing queries' impact on other queries, and extreme indexing failure cases.

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 trendHacker 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.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the amazing artwork 

The podcast discusses the importance of index maintenance in PostgreSQL databases, exploring bloat analysis, redundant indexes, and the relationship between index usage and bloat. The hosts emphasize the negative impact of not using indexes, caution against certain tools due to potential bugs, and highlight the use of vacuum in parallel and the importance of partitioning for efficient database maintenance.

Here are links to a few things we mentioned: pg_stat_statementspgFouinepgBadgerpg_querypg_stat_activityauto_explainCan auto_explain (with timing) have low overhead? (blog post by Michael)track_io_timingpgbenchPgHeropgCenterpgwatch2 (Postgres AI edition)pg_stat_kcachePASH Viewer------------------------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.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the amazing artwork 

This podcast dives deep into the topics of WAL and checkpoint tuning in Postgres. It covers the purpose of checkpoints, the importance of triggering manual checkpoints before server restart, the various uses of the write ahead log, tuning and controlling processes in PostgreSQL, the concept of checkpoint timeout, and the importance of checking and understanding Postgres parameters.