Re: Examining very large dumps

Achilleas Mantzios <achill@matrix.gatewaynet.com> writes:
>> Did you make the dump using 8.3's pg_dump?

> Yes, with 8.3.1's pg_dump (data only dump)

That would be your problem.  *Don't* use a data-only dump, it
lobotomizes all intelligence in the system and leaves it up to you
to deal with foreign-key ordering issues.  There are lots of
performance arguments against that as well.  See the advice at

http://www.postgresql.org/docs/8.3/static/populate.html

            regards, tom lane