On 05/06/2023 13:32, Merlin Moncure wrote:
> Would this help with oom killer in linux?
Hmm, I guess the OOM killer would better understand what Postgres is
doing, it's not very smart about accounting shared memory. You still
wouldn't want the OOM killer to kill Postgres, though, so I think you'd
still want to disable it in production systems.
> Isn't it true that pgbouncer provides a lot of the same benefits?
I guess there is some overlap, although I don't really think of it that
way. Firstly, pgbouncer has its own set of problems. Secondly, switching
to threads would not make connection poolers obsolete. Maybe in the
distant future, Postgres could handle thousands of connections with
ease, and threads would make that easier to achieve that, but that would
need a lot of more work.
--
Heikki Linnakangas
Neon (https://neon.tech)