Postgres Pro
Downloads
Home   >   mailing lists

Re: Occasional spike in query response time (jumps from 200ms to 45 seconds) - Mailing list pgsql-admin

From bricklen
Subject Re: Occasional spike in query response time (jumps from 200ms to 45 seconds)
Date
Msg-id CAGrpgQ-4Ozw8_7DF3sLMkqqnxNU+Wsqg6sZ4w20cZd0WAkyL1A@mail.gmail.com
Whole thread Raw
In response to Occasional spike in query response time (jumps from 200ms to 45 seconds)  (Robert Voinea <rvoinea@gmail.com>)
Responses Re: Occasional spike in query response time (jumps from 200ms to 45 seconds)  (Robert Voinea <rvoinea@gmail.com>)
List pgsql-admin
Tree view

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 by date:

Previous
From: Robert Voinea
Date:
Subject: Occasional spike in query response time (jumps from 200ms to 45 seconds)
Next
From: Kevin Grittner
Date:
Subject: Re: Occasional spike in query response time (jumps from 200ms to 45 seconds)