OK. Thanks. Uwe
On 28 March 2011 08:02, Greg Smith <g...@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 g...@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 >
