Checkpoint segments too small

Поиск
Список
Период
Сортировка
От Henrik Zagerholm
Тема Checkpoint segments too small
Дата
Msg-id CFEA46A7-AE36-4CAF-940E-D76654DA620B@mac.se
обсуждение исходный текст
Ответы Re: Checkpoint segments too small
Список pgsql-general
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?

Regards,
Henrik

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

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: Dealing with tsvector in fuctions for data split
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Checkpoint segments too small