Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3DEBE37BE27 for ; Fri, 3 Oct 2008 05:22:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10297-05 for ; Fri, 3 Oct 2008 05:22:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id D4B4737BD51 for ; Fri, 3 Oct 2008 05:22:11 -0300 (ADT) Received: (qmail invoked by alias); 03 Oct 2008 08:22:08 -0000 Received: from gmp-ea-fw-1.sun.com (EHLO dhcp-eesp05-101-124.Finland.Sun.COM) [192.18.1.36] by mail.gmx.net (mp025) with SMTP; 03 Oct 2008 10:22:08 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX18/ZP0jz9c/kOWH+SZZBZfGU827h7l3kCpTMHzAf5 4JyOz2hXxRSCeH Message-ID: <48E5D62D.7060400@gmx.net> Date: Fri, 03 Oct 2008 11:22:05 +0300 From: Peter Eisentraut User-Agent: Thunderbird 2.0.0.17 (Macintosh/20080914) MIME-Version: 1.0 To: Peter Childs CC: Postgresql Performance Subject: Re: Slow Inserts on large tables References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-FuHaFi: 0.82 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200810/21 X-Sequence-Number: 31602 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.