Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: depesz@depesz.com
Cc: Stephen Frost <sfrost@snowman.net>, Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2021-10-20T21:46:01Z
Lists: pgsql-hackers, pgsql-general 
I wrote:
> Anyway, it doesn't look like there's much hope of improving this
> aspect without a significant rewrite.

Just to close out this thread: I've now posted such a rewrite at

https://www.postgresql.org/message-id/2273648.1634764485%40sss.pgh.pa.us

			regards, tom lane

Commits

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

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