From: Chris <dmagick@gmail.com>
To: pgsql-performance@postgresql.org
Subject: import performance
Date: Tue, 14 Mar 2006 11:40:11 +1100
Message-ID: <441610EB.7070001@gmail.com> (raw)
Hi all,
I'm trying to work out why my 8.1 system is slower than my 7.4 system
for importing data.
The import is a lot of "insert into" commands - it's a converted
database from another system so I can't change it to copy commands.
My uncommented config options:
autovacuum = off
bgwriter_all_maxpages = 15
bgwriter_all_percent = 10.0
bgwriter_delay = 2000
bgwriter_lru_maxpages = 10
bgwriter_lru_percent = 5.0
checkpoint_segments = 10
commit_delay = 100000
commit_siblings = 500
temp_buffers = 500
wal_buffers = 16
max_connections = 16
shared_buffers = 256
(I was playing around with the bgwriter stuff to see if it made any
differences, so I could be making it worse).
It's a pretty small machine - 2.6GHz with 512M RAM.
My main concern is 7.4 on a smaller machine with less memory is faster
to import this data.
Suggestions on what I need to do would be fantastic, thanks!
--
Postgresql & php tutorials
http://www.designmagick.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: dmagick@gmail.com
Subject: Re: import performance
In-Reply-To: <441610EB.7070001@gmail.com>
* 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