BUG #11033: 'pg_dump -a' much slower than 'pg_dump'

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.

Responses

Browse pgsql-bugs by date

  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が効かない