Re: Can we get rid of repeated queries from pg_dump?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: depesz(at)depesz(dot)com
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Can we get rid of repeated queries from pg_dump?
Date: 2021-08-31 19:06:25
Message-ID: 1966358.1630436785@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

hubert depesz lubaczewski <depesz(at)depesz(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2021-09-01 05:45:27 Re: Can we get rid of repeated queries from pg_dump?
Previous Message Matt Zagrabelny 2021-08-31 16:36:45 Re: echo of \C foo

Browse pgsql-hackers by date

  From Date Subject
Next Message John Naylor 2021-08-31 19:06:32 Re: RFC: Improve CPU cache locality of syscache searches
Previous Message Mark Dilger 2021-08-31 18:53:32 Re: Bug fix for cache lookup failure for statistic_ext type