On Sun, Oct 27, 2002 at 13:49:27 -0800,
Garo Hussenjian <garo(at)xapnet(dot)com> wrote:
> Hello,
>
> I have a dump file from "pg_dump dbname > dump_file" of about 115 Mb that
> takes a few seconds to create and takes several hours to restore using "psql
> dbname < dump_file".
>
> I can't imagine I'm doing this correctly! What am I missing?
Enforcing constraints and updating indexes can take a lot of time.
You might get a significant speed up by not creating indexes or enforcing
constraints (foreign keys probably being the bigest worry) until after
the data gets loaded.