Re: Draft for basic NUMA observability

Jakub Wartak <jakub.wartak@enterprisedb.com>

View thread

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

To: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>

Cc: Andres Freund <andres@anarazel.de>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2025-02-27T09:05:46Z

Lists: pgsql-hackers

Attachments

v6-0003-Add-pg_shmem_numa_allocations-to-show-NUMA-zones-.patch (application/octet-stream) patch v6-0003
v6-0002-Extend-pg_buffercache-with-new-view-pg_buffercach.patch (application/octet-stream) patch v6-0002
v6-0001-Add-optional-dependency-to-libnuma-for-basic-NUMA.patch (application/octet-stream) patch v6-0001

On Wed, Feb 26, 2025 at 6:13 PM Bertrand Drouvot
<bertranddrouvot.pg@gmail.com> wrote:
[..]
> > Meanwhile v5 is attached with slight changes to try to make cfbot happy:
>
> Thanks for the updated version!
>
> FWIW, I had to do a few changes to get an error free compiling experience with
> autoconf/or meson and both with or without the libnuma configure option.
>
> Sharing here as .txt files:
>
> Also the pg_buffercache test fails without the libnuma configure option. Maybe
> some tests should depend of the libnuma configure option.
[..]

Thank you so much for this Bertrand !

I've applied those , played a little bit with configure and meson and
reproduced the test error and fixed it by silencing that NOTICE in
tests. So v6 is attached even before I get a chance to start using
that CI. Still waiting for some input and tests regarding that earlier
touchpages attempt, docs are still missing...

-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