Re: Checkpoint segments too small

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: Checkpoint segments too small
Дата
Msg-id 20070806103424.GD24616@svr2.hagander.net
обсуждение исходный текст
Ответ на Checkpoint segments too small  (Henrik Zagerholm <henke@mac.se>)
Список pgsql-general
On Mon, Aug 06, 2007 at 11:26:18AM +0200, Henrik Zagerholm wrote:
> Hi list,
>
> I'm running 8.2.4 and I've started to get these messages and even
> though I googled for some answers I couldn't find any good info
> against the 8.2 code base.
>
> 2007-08-05 04:00:58.815 CEST  LOG:  checkpoints are occurring too
> frequently (17 seconds apart)
> 2007-08-05 04:00:58.815 CEST  HINT:  Consider increasing the
> configuration parameter "checkpoint_segments".
>
> Right now I use the default setting.
>
> Is there any idea of raising these at all if I can't move them to a
> separate disk?

Yes. Just make sure you have enough diskspace for them before you do it.

//Magnus

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

Предыдущее
От: Henrik Zagerholm
Дата:
Сообщение: Checkpoint segments too small
Следующее
От: "Alain Roger"
Дата:
Сообщение: import content of XLS file into PostgreSQL