Hello, I have a fairly large DB to dump and restore as fast as possible. I'm moving from 8.0.3 to 8.2.3! :)
I normally dump with these options: -d MyDB --clean --inserts --column-inserts --format=P But the last time I tried that, the restore took foreeeeeeeeeeeeeever. So I'm looking for the fastest way to import data from the old DB to the new one. Judging from pg_dump man page the following should be the fastest dump & restore: -d MyDB --format=c --ignore-version Is there anything else I can do to make the restore as fast as possible? Thanks, Otis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Simpy -- http://www.simpy.com/ - Tag - Search - Share ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
