Re: Slow Inserts on large tables - Mailing list pgsql-performance

From Peter Eisentraut
Subject Re: Slow Inserts on large tables
Date
Msg-id 48E5D62D.7060400@gmx.net
Whole thread Raw
In response to Slow Inserts on large tables  ("Peter Childs" <peterachilds@gmail.com>)
Responses Re: Slow Inserts on large tables
List pgsql-performance
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 happen more rarely and see if that
makes a difference.


pgsql-performance by date:

Previous
From: "Peter Childs"
Date:
Subject: Slow Inserts on large tables
Next
From: "Peter Childs"
Date:
Subject: Re: Slow Inserts on large tables