Re: Publish checkpoint timing and sync files summary data to pg_stat_bgwriter

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Publish checkpoint timing and sync files summary data to pg_stat_bgwriter
Дата
Msg-id CA+TgmoZUGvBFk5b7QTcX82pwjHeUSb+Q83YPp_UrZLOJaFzj0A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Publish checkpoint timing and sync files summary data to pg_stat_bgwriter  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: Publish checkpoint timing and sync files summary data to pg_stat_bgwriter  (Greg Smith <greg@2ndquadrant.com>)
Re: Publish checkpoint timing and sync files summary data to pg_stat_bgwriter  (Peter Geoghegan <peter@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения 
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.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Removing freelist (was Re: Should I implement DROP INDEX CONCURRENTLY?)
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Next steps on pg_stat_statements normalisation