Re: buffercache/bgwriter

OK. Thanks.

Uwe

On 28 March 2011 08:02, Greg Smith <greg(at)2ndquadrant(dot)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(at)2ndQuadrant(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>