On Fri, Jul 25, 2014 at 12:10:52AM +0000, joe@tanga.com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 11033
> Logged by: Joe Van Dyk
> Email address: joe@tanga.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.
Wow, that is certainly odd.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +