checkpoint segments

Поиск
Список
Период
Сортировка
От Havasvölgyi Ottó
Тема checkpoint segments
Дата
Msg-id 007101c584d6$ca1dde30$ba00a8c0@OTTO
обсуждение исходный текст
Ответ на Transaction isolation levels  (Geert Jansen <geert@boskant.nl>)
Ответы Re: checkpoint segments  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
Hi,

I have a small database on my Windows XP, I rarely use it. Even so, the log
file show says this:

[2005-07-02 02:02:09] LOG:  received fast shutdown request

 [2005-07-02 02:02:09] LOG:  checkpoints are occurring too frequently (0
seconds apart)

 [2005-07-02 02:02:09] HINT:  Consider increasing the configuration
parameter "checkpoint_segments".

 [2005-07-02 02:02:09] LOG:  shutting down

 [2005-07-02 02:02:10] LOG:  database system is shut down

 [2005-07-02 02:02:13] LOG:  logger shutting down


My checkpoint_segments setting is default, 3, and there are 2 wal log files.
Why does it say, that "too frequenty"?
In fact what are checkpoints? These files? I couldn't understand it exactly
from the docs.

Thanks,
Otto



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Transaction isolation levels
Следующее
От: Havasvölgyi Ottó
Дата:
Сообщение: Re: checkpoint segments