Re: Slow Inserts on large tables

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Peter Childs <peterachilds(at)gmail(dot)com>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow Inserts on large tables
Date: 2008-10-03 08:22:05
Message-ID: 48E5D62D.7060400@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Peter Childs 2008-10-03 08:47:38 Re: Slow Inserts on large tables
Previous Message Peter Childs 2008-10-03 07:25:42 Slow Inserts on large tables