Top ten dangerous issues

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:
• Heavy lock contention
• Bloat control and index maintenance
• Lightweight lock contention
• Transaction ID wraparound
• 4-byte integer PKs hitting the limit
• Replication limits
• Hard limits
• Data loss
• Poor HA choice (split brain)
• Corruption of various kinds

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

And finally, some other things they mentioned:
• A great recent SQL Server-related podcast episode on tuning techniques kendralittle.com/2024/05/20/erik-darling-and-k…
• Postgres Indexes, Partitioning and LWLock:LockManager Scalability (blog post by Jeremy Schneider) ardentperf.com/2024/03/03/postgres-indexes-par…
• Do you vacuum everyday? (talk by Hannu Krosing) youtube.com/watch?v=JcRi8Z7rkPg
• pg_stat_wal pgpedia.info/p/pg_stat_wal.html
• The benefit of lz4 and zstd for Postgres WAL compression (Small Datum blog, Mark Callaghan) smalldatum.blogspot.com/2022/05/the-benefit-of…
• Split-brain in case of network partition (CloudNativePG issue/discussion) github.com/cloudnative-pg/cloudnative-pg/discu…

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With credit to:
• Jessie Draws for the elephant artwork