FPW stats? - Mailing list pgsql-hackers

From Dmitry Dolgov
Subject FPW stats?
Date
Msg-id CA+q6zcXJt2GJGQCYiei3sjSeuxO5D1TJcPS6uD9MQ8=f0KuSwg@mail.gmail.com
Whole thread Raw
Responses Re: FPW stats?  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Hi,

Recently I've heard people complaining that Postgres doesn't expose any
statistics about how many full page writes happened during some time frame.
Indeed, I couldn't find any easy way to do so, and judging from my
understanding of xloginsert.c it actually can be done per database with the
attached poc patch.

I guess it can be implemented in a more effective and optimized way, but with
what I have right now first naive pgbench tests show that slowdown is about 3%.
Before I'll dig into it more, it would be nice to hear your opinion about this
idea -  does it make sense to have something like this?

Attachment

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Should we add GUCs to allow partition pruning to be disabled?
Next
From: Geoff Winkless
Date:
Subject: Re: Is a modern build system acceptable for older platforms