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

From Tom Lane
Subject Re: Can we get rid of repeated queries from pg_dump?
Date
Msg-id 1966358.1630436785@sss.pgh.pa.us
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-hackers
hubert depesz lubaczewski <depesz@depesz.com> writes:
> My point in here is that potential optimizations regarding queries for
> pg_proc might speed up dumps for more people - as they might use things
> like postgis, but never realized that it can be much faster.

Agreed, but as I said upthread, fixing that looks like it will be
rather invasive.  Meanwhile, I went ahead and pushed the two
simple improvements discussed so far.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: Bug fix for cache lookup failure for statistic_ext type
Next
From: John Naylor
Date:
Subject: Re: RFC: Improve CPU cache locality of syscache searches