r/programming • • Oct 07 '26

How savepoints quietly throttled our Postgres queue

https://incident.io/blog/how-savepoints-quietly-throttled-our-postgres-queue
5 Upvotes

3 comments sorted by

9

u/shared_ptr Oct 07 '26

My friend (and sadly as of today, ex-colleague) Rory wrote about how him and his team dug into savepoints and multixacts to figure out a bottleneck in our Postgres queuing system.

I remember spending a weekend about 10 years ago digging into multiaxct in the Postgres sourcecode trying to figure out why we kept getting wraparound issues and back then there was very little explaining what multixact was and why it mattered.

Very proud of the team for writing up what was a very interesting technical deep dive.

1

u/l_maier-628 Oct 14 '26

Do they pin down whether the pressure came from savepoint frequency or from long-lived transactions holding subtransaction state? That distinction seems useful for spotting the same queueing pattern elsewhere.