Postgres FM

Top ten dangerous issues


Listen Later

Nikolay and Michael discuss ten dangerous Postgres related issues — ones that might be painful enough to get onto the CTO and even CEOs desk, and then what you can do proactively.
 
The ten issues discussed are:

  1. Heavy lock contention
  2. Bloat control and index maintenance  
  3. Lightweight lock contention
  4. Transaction ID wraparound
  5. 4-byte integer PKs hitting the limit
  6. Replication limits
  7. Hard limits
  8. Data loss
  9. Poor HA choice (split brain)
  10. Corruption of various kinds


Some previous episodes they mentioned that cover the issues in more detail: 

  • PgDog https://postgres.fm/episodes/pgdog
  • Performance cliffs https://postgres.fm/episodes/performance-cliffs
  • Zero-downtime migrations https://postgres.fm/episodes/zero-downtime-migrations 
  • Queues in Postgres https://postgres.fm/episodes/queues-in-postgres
  • Bloat https://postgres.fm/episodes/bloat
  • Index maintenance https://postgres.fm/episodes/index-maintenance
  • Subtransactions https://postgres.fm/episodes/subtransactions
  • Four million TPS https://postgres.fm/episodes/four-million-tps
  • Transaction ID wraparound https://postgres.fm/episodes/transaction-id-wraparound
  • pg_squeeze https://postgres.fm/episodes/pg_squeeze 
  • synchronous_commit https://postgres.fm/episodes/synchronous_commit
  • Managed service support https://postgres.fm/episodes/managed-service-support

 

And finally, some other things they mentioned: 

  • A great recent SQL Server-related podcast episode on tuning techniques https://kendralittle.com/2024/05/20/erik-darling-and-kendra-little-rate-sql-server-performance-tuning-techniques/
  • Postgres Indexes, Partitioning and LWLock:LockManager Scalability (blog post by Jeremy Schneider) https://ardentperf.com/2024/03/03/postgres-indexes-partitioning-and-lwlocklockmanager-scalability/
  • Do you vacuum everyday? (talk by Hannu Krosing) https://www.youtube.com/watch?v=JcRi8Z7rkPg
  • pg_stat_wal https://pgpedia.info/p/pg_stat_wal.html
  • The benefit of lz4 and zstd for Postgres WAL compression (Small Datum blog, Mark Callaghan) https://smalldatum.blogspot.com/2022/05/the-benefit-of-lz4-and-zstd-for.html
  • Split-brain in case of network partition (CloudNativePG issue/discussion) https://github.com/cloudnative-pg/cloudnative-pg/discussions/7462
     


~~~

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
...more
View all episodesView all episodes
Download on the App Store

Postgres FMBy Nikolay Samokhvalov and Michael Christofides

  • 4.7
  • 4.7
  • 4.7
  • 4.7
  • 4.7

4.7

20 ratings


More shows like Postgres FM

View all
Hanselminutes with Scott Hanselman by Scott Hanselman

Hanselminutes with Scott Hanselman

377 Listeners

Software Engineering Radio - the podcast for professional software developers by se-radio@computer.org

Software Engineering Radio - the podcast for professional software developers

273 Listeners

The Changelog: Software Development, Open Source by Changelog Media

The Changelog: Software Development, Open Source

285 Listeners

Talk Python To Me by Michael Kennedy

Talk Python To Me

586 Listeners

Software Engineering Daily by Software Engineering Daily

Software Engineering Daily

631 Listeners

Python Bytes by Michael Kennedy and Brian Okken

Python Bytes

214 Listeners

Data Engineering Podcast by Tobias Macey

Data Engineering Podcast

138 Listeners

Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

Syntax - Tasty Web Development Treats

989 Listeners

CoRecursive: Coding Stories by Adam Gordon Bell - Software Developer

CoRecursive: Coding Stories

185 Listeners

Scaling Postgres by Creston Jamison

Scaling Postgres

12 Listeners

Kubernetes Podcast from Google by Abdel Sghiouar, Kaslin Fields

Kubernetes Podcast from Google

180 Listeners

The Real Python Podcast by Real Python

The Real Python Podcast

138 Listeners

Hard Fork by The New York Times

Hard Fork

5,363 Listeners

Oxide and Friends by Oxide Computer Company

Oxide and Friends

47 Listeners

The Pragmatic Engineer by Gergely Orosz

The Pragmatic Engineer

53 Listeners