Hacker Blog Posts

Blogs / Company blogs

Postgres.ai Blog

postgres.ai

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,122 company

Visit postgres.ai → RSS feedOn Hacker News Feb 2020 – Apr 2024

Databases & Data 3Tools & Productivity 1Systems & Performance 1Software Engineering 1

Most pointsMost discussedMost citedNewest
1

PostgreSQL Subtransactions Considered Harmful

2021110 points41 commentsDatabases & Data details

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…