X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4245AD1BB6B for ; Wed, 3 Mar 2004 14:10:33 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 40145-04 for ; Wed, 3 Mar 2004 10:10:33 -0400 (AST) Received: from mail.enyo.de (mail.enyo.de [212.9.189.167]) by svr1.postgresql.org (Postfix) with ESMTP id 8D7DDD1BA4C for ; Wed, 3 Mar 2004 10:10:29 -0400 (AST) Received: (debugging) helo=deneb.enyo.de ip=212.9.189.171 name=deneb.enyo.de Received: from deneb.enyo.de ([212.9.189.171]) by mail.enyo.de with esmtp id 1AyX4y-0001L1-Vc for pgsql-performance@postgresql.org; Wed, 03 Mar 2004 15:10:32 +0100 Received: from fw by deneb.enyo.de with local (Exim 4.30) id 1AyX4y-0003Cm-4i for pgsql-performance@postgresql.org; Wed, 03 Mar 2004 15:10:32 +0100 Date: Wed, 3 Mar 2004 15:10:32 +0100 To: pgsql-performance@postgresql.org Subject: Re: Bulk INSERT performance in 7.4.1 Message-ID: <20040303141032.GA12276@deneb.enyo.de> References: <20040303092528.GA6647@deneb.enyo.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040303092528.GA6647@deneb.enyo.de> User-Agent: Mutt/1.5.5.1+cvs20040105i From: Florian Weimer X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/41 X-Sequence-Number: 5897 Florian Weimer wrote: > After an upgrade to 7.4.1 (from 7.3) we see a severe performance > regression in bulk INSERTs. In turns out that we were running the default configuration, and not the tuned one in /etc/postgresql. *blush* After increasing the number of checkpoint segments and the shared-memory buffers, performance is back to the expected levels. It might even be a bit faster. -- Current mail filters: many dial-up/DSL/cable modem hosts, and the following domains: atlas.cz, bigpond.com, freenet.de, hotmail.com, libero.it, netscape.net, postino.it, tiscali.co.uk, tiscali.cz, tiscali.it, voila.fr, wanadoo.fr, yahoo.com.