From: Gavin Sherry <swm@alcove.com.au>
To: Chris <dmagick@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: import performance
Date: Tue, 14 Mar 2006 11:48:28 +1100 (EST)
Message-ID: <Pine.LNX.4.58.0603141146130.16333@linuxworld.com.au> (raw)
In-Reply-To: <441610EB.7070001@gmail.com>
References: <441610EB.7070001@gmail.com>
On Tue, 14 Mar 2006, Chris wrote:
> 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
The above is a bit high.
> bgwriter_delay = 2000
This too.
> bgwriter_lru_maxpages = 10
> bgwriter_lru_percent = 5.0
>
> checkpoint_segments = 10
>
> commit_delay = 100000
> commit_siblings = 500
Way too high
>
> temp_buffers = 500
>
> wal_buffers = 16
Make this at least 64.
>
> max_connections = 16
>
> shared_buffers = 256
Make this higher too. If this is a dedicated machine with 512 MB of ram,
set it to something like 125000.
You may need to adjust shared memory settings for your operating system.
See the manual for details.
Thanks,
Gavin
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: swm@alcove.com.au, dmagick@gmail.com
Subject: Re: import performance
In-Reply-To: <Pine.LNX.4.58.0603141146130.16333@linuxworld.com.au>
* 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