Re: [GENERAL] pg_restore seems slow

2008-02-10 Thread Willem Buitendyk
I did use the 'd' switch but I didn't use the 'C' switch so I'm not sure a database was actually created. Anyways, after I used the correct switches all work fast - really fast. About a 1M records per minute. I was able to peek into the server processes to see the current copy commands in ef

Re: [GENERAL] pg_restore seems slow

2008-02-09 Thread Gurjeet Singh
On Feb 9, 2008 10:42 AM, Willem Buitendyk <[EMAIL PROTECTED]> wrote: > I'm trying to restore my database from 8.26 into 8.3 (win32) but find > the process to be exceedingly slow. The database has about 60M records. > I realize there will be differences based on hardware, available memory, > compl

[GENERAL] pg_restore seems slow

2008-02-09 Thread Willem Buitendyk
I'm trying to restore my database from 8.26 into 8.3 (win32) but find the process to be exceedingly slow. The database has about 60M records. I realize there will be differences based on hardware, available memory, complexity of records but when I first tried a restore with the verbose option