Re: buffercache/bgwriter

Поиск
Список
Период
Сортировка
От Uwe Bartels
Тема Re: buffercache/bgwriter
Дата
Msg-id AANLkTikEQK0W1viU9qmYCiJhDh0Z4YPfrs=Pt1=1Ke18@mail.gmail.com
обсуждение исходный текст
Ответ на Re: buffercache/bgwriter  (Greg Smith <greg@2ndQuadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Intel SSDs that may not suck
Следующее
От: Andy
Дата:
Сообщение: Re: Intel SSDs that may not suck