Re: buffercache/bgwriter - Mailing list pgsql-performance

From Uwe Bartels
Subject Re: buffercache/bgwriter
Date
Msg-id AANLkTikEQK0W1viU9qmYCiJhDh0Z4YPfrs=Pt1=1Ke18@mail.gmail.com
Whole thread Raw
In response to Re: buffercache/bgwriter  (Greg Smith <greg@2ndQuadrant.com>)
List pgsql-performance
OK. Thanks.

Uwe


On 28 March 2011 08:02, Greg Smith <greg@2ndquadrant.com> wrote:
On 03/24/2011 05:19 AM, Uwe Bartels wrote:
It would also be good to see how many buffers were written by backend processes grouped by Buffer Access Strategy - to better distinguish evil backend writes from wanted backend writes.

Since all these writes are being cached by the operating system, which strategy writes them out isn't that useful to track.  The only really "evil" type of writes are ones where the background writer doesn't absorb the fsync calls and the backends have to do that themselves.  And as of V9.1, that is something you can distinguish in pg_stat_bgwriter (and it's also less likely to happen, too)

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Intel SSDs that may not suck
Next
From: Andy
Date:
Subject: Re: Intel SSDs that may not suck