Re: FPW stats?

2018-05-03 Thread Robert Haas
On Wed, May 2, 2018 at 7:10 AM, Michael Paquier wrote: > 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? I'm a little doubtful about whether this particular thing

Re: FPW stats?

2018-05-02 Thread Dmitry Dolgov
> On 2 May 2018 at 13:10, Michael Paquier 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. > >

Re: FPW stats?

2018-05-02 Thread Michael Paquier
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? > I guess it can be implemented in a more effective and

FPW stats?

2018-05-02 Thread Dmitry Dolgov
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