PostgreSQL Administratoren Albtraum

• Siehe auch: Is PostgreSQL catching up with the Oracle Database?

Probleme mit PostgreSQL

• Many Forks, Cloud Variants, Extensions and Distributors
• Core Team und Major Contributors: EDB, AWS und MS
• Nicht alle Extensions sind Produktionstauglich
• PostgreSQL major version upgrades are hard (up to at least to PostgreSQL 17!)
• Collation dependency on O/S (solved in PostgreSQL 17?)
• Schlechte MVCC Implementation: The Part of PostgreSQL We Hate the Most, Yes, PostgreSQL Has Problems. But We’re Sticking With It!
• Replicas require identical O/S package versions!
• XID Counter Overflow -> Data loss
• Vacuum