{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Top ten dangerous issues","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/9aa0b37d\"></iframe>","width":"100%","height":180,"duration":2788,"description":"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.\n \nThe ten issues discussed are:\nHeavy lock contention\nBloat control and index maintenance  \nLightweight lock contention\nTransaction ID wraparound\n4-byte integer PKs hitting the limit\nReplication limits\nHard limits\nData loss\nPoor HA choice (split brain)\nCorruption of various kinds\n\nSome previous episodes they mentioned that cover the issues in more detail: \nPgDog https://postgres.fm/episodes/pgdog\nPerformance cliffs https://postgres.fm/episodes/performance-cliffs\nZero-downtime migrations https://postgres.fm/episodes/zero-downtime-migrations \nQueues in Postgres https://postgres.fm/episodes/queues-in-postgres\nBloat https://postgres.fm/episodes/bloat\nIndex maintenance https://postgres.fm/episodes/index-maintenance\nSubtransactions https://postgres.fm/episodes/subtransactions\nFour million TPS https://postgres.fm/episodes/four-million-tps\nTransaction ID wraparound https://postgres.fm/episodes/transaction-id-wraparound\npg_squeeze https://postgres.fm/episodes/pg_squeeze \nsynchronous_commit https://postgres.fm/episodes/synchronous_commit\nManaged service support https://postgres.fm/episodes/managed-service-support\n \nAnd finally, some other things they mentioned: \nA 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/\nPostgres Indexes, Partitioning and LWLock:LockManager Scalability (blog post by Jeremy Schneider) https://ardentperf.com/2024/03/03/postgres-indexes-partitioning-and-lwlocklockmanager-scalability/\nDo you vacuum everyday? (talk by Hannu Krosing) https://www.youtube.com/watch?v=JcRi8Z7rkPg\npg_stat_wal https://pgpedia.info/p/pg_stat_wal.html\nThe benefit of lz4 and zstd for Postgres WAL compression (Small Datum blog, Mark Callaghan)...","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}