From: Tom Lane <tgl@sss.pgh.pa.us>
To: depesz@depesz.com
cc: pgsql-general <pgsql-general@lists.postgresql.org>
Subject: Re: Can we get rid of repeated queries from pg_dump?
In-reply-to: <20210826140827.GA15868@depesz.com>
References: <20210826084430.GA26282@depesz.com>
 <648517.1629986527@sss.pgh.pa.us> <20210826140827.GA15868@depesz.com>
Comments: In-reply-to hubert depesz lubaczewski <depesz@depesz.com>
	message dated "Thu, 26 Aug 2021 16:08:27 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <649445.1629987629.1@sss.pgh.pa.us>
Date: Thu, 26 Aug 2021 10:20:29 -0400
Message-ID: <649446.1629987629@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/649446.1629987629%40sss.pgh.pa.us>
Precedence: bulk

hubert depesz lubaczewski <depesz@depesz.com> writes:
> On Thu, Aug 26, 2021 at 10:02:07AM -0400, Tom Lane wrote:
>> hubert depesz lubaczewski <depesz@depesz.com> writes:
>>> Wouldn't it be possible to get all type formats at once, and cache them
>>> in pg_dump? Or at the very least reuse already received information?

>> Send a patch ...

> Yeah, that's not going to work, my C skills are next-to-none :(
> I guess I'll have to wait till someone else will assume it's a problem,
> someone with skills to do something about it.

Well, you could move it forward by doing the legwork to identify which
queries are worth merging.  Is it really sane to do a global "select
format_type() from pg_type" query and save all the results on the client
side?  I wonder whether there are cases where that'd be a net loss.
You could do the experimentation to figure that out without necessarily
having the C skills to make pg_dump actually do it.

			regards, tom lane