| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | jerome(at)gmanmi(dot)tv, PostgresGeneral <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PG_DUMP too slow... |
| Date: | 2003-05-09 10:27:32 |
| Message-ID: | 200305091127.32991.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Marques | 2003-05-09 11:36:59 | Re: informix to postgres tools? |
| Previous Message | Frank Millman | 2003-05-09 10:24:13 | Re: How return a refcusor using functions???? |