Re: Adding basic NUMA awareness - Preliminary feedback and outline for an extensible approach - Mailing list pgsql-hackers

From Cédric Villemain
Subject Re: Adding basic NUMA awareness - Preliminary feedback and outline for an extensible approach
Date
Msg-id f1f03ad5-91b4-4028-8304-4e60c3b0a469@data-bene.io
Whole thread Raw
In response to Re: Adding basic NUMA awareness - Preliminary feedback and outline for an extensible approach  (Tomas Vondra <tomas@vondra.me>)
List pgsql-hackers
>> * Others might use it to integrate PostgreSQL's own resources (e.g.,
>> "areas" of shared buffers) into policies.
>>
>> Hope this perspective is helpful.
>
> Can you explain how you want to manage this by an extension defined at
> the SQL level, when most of this stuff has to be done when setting up
> shared memory, which is waaaay before we have any access to catalogs?

I should have said module instead, I didn't follow carefully but at some
point there were discussion about shared buffers resized "on-line".
Anyway, it was just to give some few examples, maybe this one is to be
considered later (I'm focused on cgroup/psi, and precisely reassigning
PIDs as needed).


--
Cédric Villemain +33 6 20 30 22 52
https://www.Data-Bene.io
PostgreSQL Support, Expertise, Training, R&D




pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: C11 / VS 2019
Next
From: Japin Li
Date:
Subject: Re: Inconsistent LSN format in pg_waldump output