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.
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance