From: | joe(at)tanga(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #11033: 'pg_dump -a' much slower than 'pg_dump' |
Date: | 2014-07-25 00:10:52 |
Message-ID: | 20140725001052.16600.86470@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 11033
Logged by: Joe Van Dyk
Email address: joe(at)tanga(dot)com
PostgreSQL version: 9.3.5
Operating system: Ubuntu 12.04
Description:
I've got a small database that takes about 0.8 seconds to dump with
'pg_dump' and about 11 seconds to dump with 'pg_dump -a'.
I've narrowed it down to the foreign key constraints in the database, if
those are removed, then 'pg_dump -a' becomes fast again.
I can't come up with an artificial test case. I can reproduce it using our
company's db schema. I don't want to publicly post that schema to the
mailing list, but I'd be happy to send the schema that shows the problem to
someone privately.
I can reproduce the problem in 9.3.4 and 9.4.beta1.
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Van Dyk | 2014-07-25 00:23:20 | Re: BUG #11033: 'pg_dump -a' much slower than 'pg_dump' |
Previous Message | Honji Aharen | 2014-07-24 23:45:04 | pg_dumpで--schema=myschemaが効かない |