zlacker

[return to "The part of Postgres we hate the most: Multi-version concurrency control"]
1. sppras+Ul[view] [source] 2023-04-26 18:52:24
>>andren+(OP)
This post has a valid point. But the last line makes it clear why they care so much about it.

Yeah, table bloat and transaction ID wraparounds are terrible, but easily avoidable if you follow a few simple guidelines. Typically in my experience, best way to avoid these issues are to set sensible vacuum settings and track long running queries.

I do hate the some of the defaults in the Postgres configuration are too conservative for most workloads.

◧◩
2. LunaSe+IO[view] [source] 2023-04-26 21:14:42
>>sppras+Ul
Paying an overhead cost of 53 bytes per row is also too expensive for MVCC in my opinion.
[go to top]