Why we spent the last month eliminating PostgreSQL subtransactions
GitLab traced replica stalls to Postgres subtransaction overflow and removed subtransactions from its code.
- Published
- 2021-09-29
- Scale
- Not stated in source
- Techniques
- query optimization read replicas
- Stack
- PostgreSQL Ruby on Rails
Try this stack yourself
- Railway · Deploy something like this on Railway: spin up PostgreSQL and Ruby on Rails plus your app in a few clicks. New accounts get $20 in credit (applied when you pick a paid plan).
Railway isn't part of GitLab's setup in this story. It's just an easy place to try the same building blocks.
Some links above are affiliate links: if you sign up, How They Scaled may earn a commission at no extra cost to you. We only list tools that fit the stack in the story.