Re: [GENERAL] Horrible pg_restore performance, please help

2003-07-19 Thread Tom Lane
brice <[EMAIL PROTECTED]> writes: > We're running Postgres 7.1.3 on a Redhat Linux system with 800 MHz CPU, > 1GB ram, 1.5 GB Swap. This is obviously not a screamer of a box, but > its not terrible. > We're trying to import a 32 MB dump file and its taking forever. We've > tried multiple cfg chan

Re: [GENERAL] Horrible pg_restore performance, please help

2003-07-19 Thread Jason Godden
Hi Brice, Thats very wrong... Whilst changing conf settings will speed things up it still shouldn't affect loading a 32mb dump file. Have you tried restarting PG with logging and then piping the dump file through psql? You should find that you get a lot more direct feedback from psql. This