Re: import performance

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