From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: depesz@depesz.com, Stephen Frost <sfrost@snowman.net>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Subject: Re: Can we get rid of repeated queries from pg_dump?
Date: Sun, 29 Aug 2021 09:13:15 -0400
Message-ID: <202108291313.oufovwqmwm67@alvherre.pgsql> (raw)
In-Reply-To: <1082810.1630189581@sss.pgh.pa.us>
On 2021-Aug-28, Tom Lane wrote:
> Here is a second patch, quite independent of the first one, that
> gets rid of some other repetitive queries.
Another pointlessly repetitive query is in getTriggers, which we run
once per table to be dumped containing triggers. We could reduce that
by running it in bulk for many relations at a time. I suppose it's
normally not hurtful, but as we grow the number of partitions we allow
it's going to become a problem.
No patch from me for now — if someone wantw to volunteer one, it looks
simple enough ...
--
Álvaro Herrera Valdivia, Chile — https://www.EnterpriseDB.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: alvherre@alvh.no-ip.org, tgl@sss.pgh.pa.us, sfrost@snowman.net, laurenz.albe@cybertec.at, pgsql-general@lists.postgresql.org
Subject: Re: Can we get rid of repeated queries from pg_dump?
In-Reply-To: <202108291313.oufovwqmwm67@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox