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: 
 
And finally, some other things they mentioned: 

~~~

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:

With credit to:
  • Jessie Draws for the elephant artwork

Some kind things our listeners have said