News for hackers. Stuff that matters.
Re:Pgagroal: High-performance connection pool for PostgreSQL by kasey_junk on Monday November 22, 2021 @09:06AM (#29306393)
Pretty good discussion of Postgres’ process bottlenecks: https://www.citusdata.com/blog/2020/10/08/analyzing-connecti...

Summary: The resource per process issue is isolated to just the transaction isolation mechanism and can likely be improved but you are never getting around the context switching and memory locality issues of the per process model.

There are no comments on this comment yet.