Re: hanging for 30sec when checkpointing

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: hanging for 30sec when checkpointing
Дата
Msg-id 20040206192502.GB22668@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: hanging for 30sec when checkpointing  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
On Fri, Feb 06, 2004 at 12:34:47PM -0500, Tom Lane wrote:
> 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.

In my experience, though, they do hurt _quite substantially_ during
the checkpoint.  If you need fast all the time, cranking that
interval too high will definitely hurt you.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.
        --Philip Greenspun

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

Предыдущее
От: Naomi Walker
Дата:
Сообщение: Recycled Log Files
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Recycled Log Files