Re: Per backend relation statistics tracking

From: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Per backend relation statistics tracking
Date: 2025-09-01 14:11:47
Message-ID: aLWpo58hx0OiCmRq@ip-10-97-1-34.eu-west-3.compute.internal
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Tue, Aug 26, 2025 at 06:38:41AM +0000, Bertrand Drouvot wrote:
> On Mon, Aug 25, 2025 at 08:28:04PM -0400, Andres Freund wrote:
> > FWIW, I think this was done wrongly for the per-backend IO stats too. I've
> > seen the increased overhead in profiles
>
> That's indeed something that could be improved for the backends IO stats too. I'll
> work on this for 19 (that's probably too late for 18 and not that alarming?).

The concern for the backends IO stats is addressed in [1].

[1]: https://www.postgresql.org/message-id/flat/aLWonxez0MBSqEvA%40ip-10-97-1-34.eu-west-3.compute.internal

Regards,

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jelte Fennema-Nio 2025-09-01 14:44:41 Re: Extension security improvement: Add support for extensions with an owned schema
Previous Message Bertrand Drouvot 2025-09-01 14:07:27 Get rid of pgstat_count_backend_io_op*() functions