Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables.
Date
Msg-id 1347707.1760578289@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables.  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables.
List pgsql-bugs
David Rowley <dgrowleyml@gmail.com> writes:
> Just to put that to the test, I tried the attached.

I'm confused by all the extraneous changes in this?

> i.e about 3.5x faster with ignore_system_indexes and 38% faster without.

Very promising, but I'm still confused.

            regards, tom lane



pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables.
Next
From: David Rowley
Date:
Subject: Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables.