Re: why restoring a dump file is sooo slow

Reynard Hilman wrote:
> Hi,
>
> I'm trying to restore a dump file that I created using:
> pg_dump -CD dbname > dump.sql
>
> the dump file size is about 87 Mb.
>
> so I did this to restore:
> psql -f dump.sql -U user template1
>
> It takes almost an hour and a half to restore the database.

This there a reason you are using the 'D' option to dump the database
as INSERTs? A dump which uses COPY (the default) instead will reload
much more quickly.

Mike Mascari
mascarm@mascari.com