Re: 7.1.3 : copy from stdin is very slow!

>root(at)database:~ #zcat dump.out.gz | psql -Upostgres dbname -c "copy
>table_name from stdin;"
>
>This crawls on 7.1.3, and it went very quickly on 7.0.3 ... I must
>have a feature turned on that I shouldn't. Any ideas? If I need to
>share more info, just let me know what I need to share.
>
>CG

Been copying from stdin for about 33 hours... I hate to stop it now. Here's
what I've done this morning to aid in perhaps getting this dump over with!

Edited /usr/local/pgsql/data/postgresql.conf:

max_connections = 64
sort_mem = 1024
shared_buffers = 2*max_connections
fsync=false
wal_buffers = 16
wal_files = 64
wal_sync_method = fsync
wal_debug = 0
commit_delay = 0
commit_siblings = 5
checkpoint_segments = 6
checkpoint_timeout = 300

then:

root(at)database:~ #killall -HUP postmaster

...
Still crawling. I thought I understood properly the idea for removing fsync,
and increasing the buffer and wal settings. No effect on the insert, tho...

Any ideas or advice welcome!

CG

__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com