Re: Redesign per-backend statistics

From: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org, Andres Freund <andres(at)anarazel(dot)de>, Sami Imseih <samimseih(at)gmail(dot)com>
Subject: Re: Redesign per-backend statistics
Date: 2026-09-21 07:15:44
Message-ID: arDZoI/5xHU2utRh@bdtpg
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Thu, Aug 13, 2026 at 03:41:58PM +0000, Bertrand Drouvot wrote:
> Hi,
>
> On Mon, Aug 10, 2026 at 02:45:16PM +0000, Bertrand Drouvot wrote:
> > Given that the cost is still sub millisecond at hundreds of connections and a few
> > milliseconds at 10000 and given the impact mentioned above, I don't think this is
> > a practical blocker though. What do you think?
> >
>
> A rebase was needed, so while at it, I implemented what we have discussed so far,
> means:
>
> - moved the generic per-backend statistics infrastructure to a new pgstat_per_backend.c
> file
> - split the previous 0005 into the IO migration and the removal of PGSTAT_KIND_BACKEND
> and pgstat_backend.c.

PFA another mandatory rebase (tiny change to test_misc/meson.build).

Regards,

--
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

Attachment Content-Type Size
v3-0001-pgstat-add-tests-for-per-backend-statistics.patch text/x-diff 21.2 KB
v3-0002-pgstat-add-new-infrastructure-for-per-backend-sta.patch text/x-diff 25.4 KB
v3-0003-pgstat-move-WAL-statistics-to-new-per-backend-inf.patch text/x-diff 20.8 KB
v3-0004-pgstat-move-Lock-statistics-to-new-per-backend-in.patch text/x-diff 21.3 KB
v3-0005-pgstat-move-IO-statistics-to-new-per-backend-infr.patch text/x-diff 33.4 KB
v3-0006-pgstat-remove-PGSTAT_KIND_BACKEND.patch text/x-diff 13.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2026-09-21 07:19:47 Re: [Patch] Fix pg_get_multixact_stats() over-reporting members on a hot standby
Previous Message Bharath Rupireddy 2026-09-21 07:12:17 WAL segment file descriptor leak on read errors can PANIC the server