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