Re: Can we get rid of repeated queries from pg_dump? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Can we get rid of repeated queries from pg_dump?
Date
Msg-id 20210828063824.GA11579@depesz.com
Whole thread Raw
In response to Re: Can we get rid of repeated queries from pg_dump?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, Aug 27, 2021 at 05:23:23PM -0400, Tom Lane wrote:
> I experimented with the attached, very quick-n-dirty patch to collect
> format_type results during the initial scan of pg_type, instead.  On the
> regression database in HEAD, it reduces the number of queries pg_dump
> issues from 3260 to 2905; but I'm having a hard time detecting any net
> performance change.
> (This is not meant for commit as-is; notably, I didn't bother to fix
> getTypes' code paths for pre-9.6 servers.  It should be fine for
> performance testing though.)

Hi,
thanks a lot for this. Will test and report back, most likely on Monday,
though.

Best regards,

depesz




pgsql-general by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Idempotent DDL Updates
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Can we get rid of repeated queries from pg_dump?