On Sat, Mar 8, 2025 at 12:52 AM Hari Krishna Sunder <hari.db.pg@gmail.com> wrote:
To improve the performance of pg_dump can we add a new sql function that can operate more efficiently than the pg_stats view? It could also take in an optional list of oids to filter on.
This will help speed up the dump and restore within pg18 and future upgrades to higher pg versions.
We can't install functions on the source database - it might be a read replica.
