Postgres.ai Blog company blog

PostgreSQL Subtransactions Considered Harmful

by @Database_Lab postgres.ai published 2021-08-31

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…

Points

110

HN comments

41

Submissions

1

Cited by

0 commenters

Databases & DataSystems & Performance2021

Related posts from the same era

Hosting SQLite databases on GitHub Pages or any static file hoster

Pphiresky20211,812 points314 commentscited by 26 details

I'm all-in on server-side SQLite

Fly.io Blog20221,353 points565 commentscited by 16 details

AWS announces forks of Elasticsearch and Kibana

AWS Blog20211,314 points935 comments details

CRDTs are the future

Joseph Gentle20201,181 points357 commentscited by 12 details

Things I wished more developers knew about databases

Jaana Dogan20201,011 points445 comments details

SQLite is not a toy database

Anton Zhiyanov2021986 points484 comments details