Re: PG_DUMP too slow...

On Friday 09 May 2003 7:08 pm, jerome wrote:
> im tried to dump a table with 10 rows...
> its like taking me 6 years.. did i do something bad that pg_dump behaves
> like this... hheehhe
>
> im working on a 4 Processor , RH7.3.. w/ postgresql-7.2.1-5 sitting on
> it...
>
> can someone tell me what happened?
>
> btw i tried to place a -v option these are the outputs..
>
> pg_dump: saving database definition
> pg_dump: last built-in oid is 16554
> pg_dump: reading user-defined types
> pg_dump: reading user-defined functions
> pg_dump: reading user-defined aggregate functions
> pg_dump: reading user-defined operators
> pg_dump: reading user-defined tables
> .........................................

1. Can you give us a copy of the precise command-line you are using and also a
select count(*) and \dt on the table in question?

2. Does this problem happen only on this table, or all tables?

3. Does this happen when dumping schema only (--schema-only)?

I do seem to remember some bug-fix in pg_dump in the 7.2 series, might be
worth checking the release notes section of the online manuals.
--
  Richard Huxton