From: Florian Weimer <fw@deneb.enyo.de>
To: pgsql-performance@postgresql.org
Subject: Bulk INSERT performance in 7.4.1
Date: Wed, 3 Mar 2004 10:25:28 +0100
Message-ID: <20040303092528.GA6647@deneb.enyo.de> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: fw@deneb.enyo.de
Subject: Re: Bulk INSERT performance in 7.4.1
In-Reply-To: <20040303092528.GA6647@deneb.enyo.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox