Re: Occasional spike in query response time (jumps from 200ms to 45 seconds)

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: Occasional spike in query response time (jumps from 200ms to 45 seconds)
Дата
Msg-id CAGrpgQ-4Ozw8_7DF3sLMkqqnxNU+Wsqg6sZ4w20cZd0WAkyL1A@mail.gmail.com
обсуждение исходный текст
Ответ на Occasional spike in query response time (jumps from 200ms to 45 seconds)  (Robert Voinea <rvoinea@gmail.com>)
Ответы Re: Occasional spike in query response time (jumps from 200ms to 45 seconds)
Список pgsql-admin
Дерево обсуждения

On Thu, Nov 7, 2013 at 2:44 AM, Robert Voinea <rvoinea@gmail.com> wrote:

Could you give me some hints on what to look for?
What might be causing this behavior?

Possibly checkpointing is the problem? Is "log_checkpoints" enabled in your postgresql.conf?  What is "checkpoint_completion_target" set to?

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

Предыдущее
От: Robert Voinea
Дата:
Сообщение: Occasional spike in query response time (jumps from 200ms to 45 seconds)
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Occasional spike in query response time (jumps from 200ms to 45 seconds)