Re:Index bloat reduced in PostgreSQL v14
by fulafel on Saturday September 11, 2021 @07:56AM
(#28491218)
Interesting that the graph goes up to 10k connections without any cliff in throughput, I wonder what use cases people have beyond that. Or maybe the issue with idling connections is memory usage?
[ Parent
| on HN ]
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.