From: | Dmitry Dolgov <9erthalion6(at)gmail(dot)com> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: FPW stats? |
Date: | 2018-05-02 12:02:00 |
Message-ID: | CA+q6zcUqytu82Bfe6YLfE+2JzQd7WyQv2D7Aq6jd+O_7MF28tg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> On 2 May 2018 at 13:10, Michael Paquier <michael(at)paquier(dot)xyz> wrote:
> On Wed, May 02, 2018 at 12:22:34PM +0200, Dmitry Dolgov wrote:
>> Recently I've heard people complaining that Postgres doesn't expose any
>> statistics about how many full page writes happened during some time
>> frame.
>
> pg_waldump --stats?
Yep, pg_waldump is the only option so far, but I thought about something that
will directly expose this info.
> The bar to add new fields into pgstat structures is usually quite high
> depending on the location where those are added. For example not so
> long ago there was a patch discussed about adding more fields to
> PgStat_StatTabEntry, which has been rejected as pgstat can be a problem
> for users with many tables. See here:
> https://www.postgresql.org/message-id/1323.1511624064%40sss.pgh.pa.us
>
> Your patch adds a new field to PgStat_StatDBEntry? Wouldn't you
> increase the bottleneck of deployments with many databases? What's
> actually your use case?
This was discussed mostly in the context of benchmarking and understanding IO
for different workloads. I actually never realized that adding a new stats
field can have significant impact in those cases when there are too many
databases, and yeah, I'm afraid it may be not justified in this context.
From | Date | Subject | |
---|---|---|---|
Next Message | John Naylor | 2018-05-02 12:19:51 | Re: inconsistency and inefficiency in setup_conversion() |
Previous Message | Thomas Munro | 2018-05-02 11:18:28 | Re: Optimize Arm64 crc32c implementation in Postgresql |