Re: pg_dump + function/table hierarchy

Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>

From: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
To: Philip Warner <pjw@rhyme.com.au>
Cc: pgsql-hackers@postgresql.org
Date: 2000-07-31T18:52:46Z
Lists: pgsql-hackers
> This is fixed in the next version as well as an experimental version for
> 7.0.2 found at:
> 
>     ftp://ftp.rhyme.com.au/pub/postgresql/pg_dump/blobs/
> 
> The solution (as suggested by Tom Lane) was to sort the items by OID before
> dumping them. This is not a perfect solution, but it will cover 95% of cases.
I tried this new pg_dump. It worked for me very well. But, for a
database with 10000 rows it wasn't too fast dumping out (twice slower than
the original one) and restoring it was three times slower.

Thanks again, Zoltan