Horton

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

Adrian Klaver <adrian.klaver@aklaver.com>

View thread View on postgr.es
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: depesz@depesz.com, pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2021-08-26T14:34:26Z
Lists: pgsql-hackers, pgsql-general 
On 8/26/21 1:44 AM, hubert depesz lubaczewski wrote:
> Hi,
> I have following case: local pg_dump (v15) connecting to remote
> PostgreSQL (v12).

So you are using a dev version of pg_dump or is that a typo?

> 
> It's been 15 minutes, and pg_dump (called: pg_dump -v -s -f schema.dump,
> with env variables configuring db connection) hasn't written even single
> byte to schema.dump)

What happens if you run without the -v?

> 
> depesz
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Commits

  1. In pg_dump, avoid doing per-table queries for RLS policies.

  2. Cache the results of format_type() queries in pg_dump.