Re: statistics buffer is full

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: statistics buffer is full
Дата
Msg-id 8555.1076297006@sss.pgh.pa.us
обсуждение исходный текст
Ответ на statistics buffer is full  (Bjoern Metzdorf <bm@turtle-entertainment.de>)
Список pgsql-admin
Bjoern Metzdorf <bm@turtle-entertainment.de> writes:
> one of our heavy loaded postgresql servers regularly gives
> LOG:  statistics buffer is full

You could try increasing PGSTAT_RECVBUFFERSZ in include/pgstat.h
(this will require recompiling src/backend/postmaster/pgstat.c
to take effect).  I'm not convinced it will help; it may just allow
the stats collector to fall further behind.  But if your problem
is load spikes it might help.

            regards, tom lane

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

Предыдущее
От: Bjoern Metzdorf
Дата:
Сообщение: statistics buffer is full
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: hanging for 30sec when checkpointing