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-08-13 15:41:58
Message-ID: an3lxtz4TaYXXg/8@bdtpg
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Regards,

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

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2026-08-13 15:46:07 Make tsqueryout() use a StringInfo
Previous Message Greg Sabino Mullane 2026-08-13 15:37:53 Re: CI slowdown due to PG_TEST_INITDB_EXTRA_OPTS