Re:Index bloat reduced in PostgreSQL v14
by pgaddict on Saturday September 11, 2021 @06:54PM
(#28496857)
Yeah, the absence of a sudden cliff is very nice. I think we fixed the main causes back in ~9.5. But the gradient at the end is pretty clear, and even at 10k the throughput is already less than 50% of the max. And it's dropping faster and faster.
It's also important to keep in mind this is an extremely simple workload, essentially just read-only point queries, on about 3GB of data.
It's also important to keep in mind this is an extremely simple workload, essentially just read-only point queries, on about 3GB of data.