Re: hanging for 30sec when checkpointing

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: hanging for 30sec when checkpointing
Дата
Msg-id 1529.1076088887@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: hanging for 30sec when checkpointing  (Shane Wright <me@shanewright.co.uk>)
Ответы Re: hanging for 30sec when checkpointing  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-admin
Shane Wright <me@shanewright.co.uk> writes:
> Although, is there any performance implication of not doing checkpoints
> very often?  (aside from, I assume, that each checkpoint will take
> longer and hence saturate available I/O for longer)

Mmm, right, I forgot to mention that one, which was a bit silly
considering that that was the focus of the discussion.  No, infrequent
checkpoints won't hurt performance between checkpoints.

            regards, tom lane

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

Предыдущее
От: kaolin fire
Дата:
Сообщение: FATAL 2: (pg_clog ... no such file or directory)
Следующее
От: Naomi Walker
Дата:
Сообщение: Recycled Log Files