Re:An early look at Postgres 14: Performance and monitoring ...
by foota on Saturday May 22, 2021 @04:48PM
(#27250123)
Out of curiosity, do you know what causes this?
[ Parent
| on HN ]
Re:An early look at Postgres 14: Performance and monitoring ...
by agacera on Saturday May 22, 2021 @06:11PM
(#27250722)
They mention this in the article. But to sum up, each connection in PG is handled by its own OS process. Postgres behind the scenes is composed by multiple single-threaded applications.
This comes with the advantes for Pg developers (and us!) that they don't need to deal with tons of data races issues, but the trade off is that memory wise, a process takes way more memory than a thread.