Re: Draft for basic NUMA observability

Jakub Wartak <jakub.wartak@enterprisedb.com>

From: Jakub Wartak <jakub.wartak@enterprisedb.com>

To: Nazir Bilal Yavuz <byavuz81@gmail.com>

Cc: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>, Andres Freund <andres@anarazel.de>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2025-03-27T13:02:03Z

Lists: pgsql-hackers

Attachments

v16-0001-Add-optional-dependency-to-libnuma-Linux-only-fo.patch (application/octet-stream) patch v16-0001
v16-0002-This-extracts-code-from-contrib-pg_buffercache-s.patch (application/octet-stream) patch v16-0002
v16-0003-Extend-pg_buffercache-with-new-view-pg_buffercac.patch (application/octet-stream) patch v16-0003
v16-0004-Add-pg_shmem_numa_allocations-to-show-NUMA-memor.patch (application/octet-stream) patch v16-0004

On Thu, Mar 27, 2025 at 12:31 PM Nazir Bilal Yavuz <byavuz81@gmail.com> wrote:
>
> Hi,
>
> Thank you for working on this!
>
> On Wed, 19 Mar 2025 at 12:06, Jakub Wartak
> <jakub.wartak@enterprisedb.com> wrote:
> >
> > On Tue, Mar 18, 2025 at 3:29 PM Bertrand Drouvot
> > <bertranddrouvot.pg@gmail.com> wrote:
> >
> > Hi! v15 attached, rebased, CI-tested, all fixed incorporated.
>
> This needs to be rebased after 8eadd5c73c.

Hi Nazir, thanks for spotting! I've not connected the dots with AIO
going in and my libnuma dependency blowing up... Attached is rebased
v16 that passed my CI run.

-J.

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

doc: Correct pg_shmem_allocations_numa.size data type
- b8a6078ca8f4 18.0 landed
Add pg_buffercache_numa view with NUMA node info
- ba2a3c2302f1 18.0 landed
Add support for basic NUMA awareness
- 65c298f61fc7 18.0 landed
Introduce pg_shmem_allocations_numa view
- 8cc139bec34a 18.0 landed