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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: Nathan Bossart <nathandbossart(at)gmail(dot)com>, andrewbille(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables.
Date: 2025-10-16 01:31:29
Message-ID: 1347707.1760578289@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

David Rowley <dgrowleyml(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

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