"Peter Childs" <[EMAIL PROTECTED]> writes:
> 2008/10/3 Peter Eisentraut <[EMAIL PROTECTED]>:
>> Then show us your checkpointing-related parameters.
> I've currently got them set to
> checkpoint_segments = 3
> checkpoint_timeout = 180s
> checkpoint_completion_target = 0.5
> after reading that doi
ECTED]>
Subject: Re: [PERFORM] Slow Inserts on large tables
To:
Cc: "Postgresql Performance"
Date: Friday, October 3, 2008, 9:47 AM
2008/10/3 Peter Eisentraut <[EMAIL PROTECTED]>:
> Peter Childs wrote:
>>
>> I have a problem where by an insert on a "large&quo
2008/10/3 Peter Eisentraut <[EMAIL PROTECTED]>:
> Peter Childs wrote:
>>
>> I have a problem where by an insert on a "large" table will sometimes
>> take longer than usual.
>
>> I think the problem might have something to do with checkpoints,
>
> Then show us your checkpointing-related parameters.
Peter Childs wrote:
I have a problem where by an insert on a "large" table will sometimes
take longer than usual.
I think the problem might have something to do with checkpoints,
Then show us your checkpointing-related parameters. Or try to set them
to a lot higher values so checkpoints ha
I have a problem where by an insert on a "large" table will sometimes
take longer than usual.
Usually the inserts are quick then from time to time they will take a
long time sometimes as much as 10seconds or longer. (But usually under
500ms which is when I start logging them)
The queries are slow
