Re: proposal: Allocate work_mem From Pool - Mailing list pgsql-hackers

From John Naylor
Subject Re: proposal: Allocate work_mem From Pool
Date
Msg-id CAFBsxsH9KF8_9H5aczTPh5hFt4Leat_Xcnw=cqaiazwwzV_qwQ@mail.gmail.com
Whole thread Raw
In response to RE: proposal: Allocate work_mem From Pool  ("Joseph D Wagner" <joe@josephdwagner.info>)
Responses Re: proposal: Allocate work_mem From Pool
List pgsql-hackers

On Tue, Jul 12, 2022 at 5:55 PM Joseph D Wagner <joe@josephdwagner.info> wrote:
> Before I try to answer that, I need to know how the scheduler works.

As I understand the term used, there is no scheduler inside Postgres for user connections -- they're handled by the OS kernel. That's probably why it'd be a difficult project to be smart about memory -- step one might be to invent a scheduler. (The autovacuum launcher and checkpointer, etc have their own logic about when to do things, but while running they too are just OS processes scheduled by the kernel.)

--
John Naylor
EDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication
Next
From: "Drouvot, Bertrand"
Date:
Subject: Re: Patch proposal: New hooks in the connection path