Re: Publish checkpoint timing and sync files summary data to pg_stat_bgwriter
Greg Smith <greg@2ndquadrant.com>
From: Greg Smith <greg@2ndquadrant.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Jeff Janes <jeff.janes@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-01-24T04:29:04Z
Lists: pgsql-hackers
Robert Haas wrote: > On Sat, Jan 21, 2012 at 6:32 PM, Jeff Janes <jeff.janes@gmail.com> wrote: > >> I'm finding the backend_writes column pretty unfortunate. The only >> use I know of for it is to determine if the bgwriter is lagging >> behind. Yet it doesn't serve even this purpose because it lumps >> together the backend writes due to lagging background writes, and the >> backend writes "by design" due to the use buffer access strategy >> during bulk inserts. >> > > +1 for separating those. > I'm tied up with some on-site things until Friday, can rev the patch with this in mind (and clear some of my overall review work pile) then. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com