1
Common DB schema change mistakes in Postgres
Common DB schema change mistakes and how to avoid them in PostgreSQL development.
Postgres.ai Blog
We fix Postgres trouble and keep it fixed. Every change, upgrades included, is rehearsed on a full copy of your data with evidence before it lands.
- Popular posts
- 3
- Total points
- 641
- HN comments
- 158
- Rank
- #2,121 company
Visit postgres.ai → RSS feedOn Hacker News Feb 2020 – Apr 2024
Databases & Data 3Tools & Productivity 1Systems & Performance 1Software Engineering 1
2
3
PostgreSQL Subtransactions Considered Harmful
PostgreSQL subtransactions (nested transactions) may cause multiple performance and scalability issues: higher rates of XID growth and higher risks of transaction ID wraparound, performance degradation when more than PGPROC_MAX_CACHED_SUBXIDS (64) are used in a session, drastic performance slowdowns when…