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 31C5ED1BCB9 for ; Wed, 3 Mar 2004 09:25:53 +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 41916-03 for ; Wed, 3 Mar 2004 05:25:38 -0400 (AST) Received: from mail.enyo.de (mail.enyo.de [212.9.189.167]) by svr1.postgresql.org (Postfix) with ESMTP id 71BFCD1B8B7 for ; Wed, 3 Mar 2004 05:25:33 -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 1AySd6-0000CX-TU for pgsql-performance@postgresql.org; Wed, 03 Mar 2004 10:25:28 +0100 Received: from fw by deneb.enyo.de with local (Exim 4.30) id 1AySd6-0001mF-Lb for pgsql-performance@postgresql.org; Wed, 03 Mar 2004 10:25:28 +0100 Date: Wed, 3 Mar 2004 10:25:28 +0100 To: pgsql-performance@postgresql.org Subject: Bulk INSERT performance in 7.4.1 Message-ID: <20040303092528.GA6647@deneb.enyo.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.5.1+cvs20040105i From: Florian Weimer X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/39 X-Sequence-Number: 5895 After an upgrade to 7.4.1 (from 7.3) we see a severe performance regression in bulk INSERTs. This is apparently caused by constant checkpointing (every 10 to 20 seconds). I've already increased the number of checkpoint segments to 32, but currently, there are just 10 or 11 files in the pg_xlog directory. With 7.3, we had configured checkpoint_segements at 16, and there were 33 pg_xlog files. Checkpoints happened every couple of minutes. How can I reduce the checkpoint frequency? (I'd like to try that first because it's the most obvious anomaly. Maybe we can look at the involved table later.) -- 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.