Re: Let's make PostgreSQL multi-threaded

Merlin Moncure <mmoncure@gmail.com>

From: Merlin Moncure <mmoncure@gmail.com>
To: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: Ranier Vilela <ranier.vf@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>, Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: 2023-06-05T17:32:34Z
Lists: pgsql-hackers
On Mon, Jun 5, 2023 at 12:25 PM Heikki Linnakangas <hlinnaka@iki.fi> wrote:

> We currently bend over backwards to make all allocations fixed-sized in
> shared memory. You learn to live with that, but a lot of things would be
> simpler if you could allocate and free in shared memory more freely.
> It's no panacea, you still need to be careful with locking and
> concurrency. But a lot simpler.


Would this help with oom killer in linux?

Isn't it true that pgbouncer provides a lot of the same benefits?

merlin