Bulk INSERT performance in 7.4.1

From: Florian Weimer <fw(at)deneb(dot)enyo(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Bulk INSERT performance in 7.4.1
Date: 2004-03-03 09:25:28
Message-ID: 20040303092528.GA6647@deneb.enyo.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2004-03-03 11:32:22 Re: Scaling further up
Previous Message Paul Thomas 2004-03-03 08:57:18 Re: Scaling further up