On Wed, May 15, 2024 at 10:15:13PM +0200, Daniel Gustafsson wrote: > With the typarray caching from the patch attached here added *and* Nathan's > patch from [0] added: > > $ time ./bin/pg_dump --schema-only --quote-all-identifiers --binary-upgrade \ > --format=custom --file a postgres > /dev/null > > real 0m1.566s > user 0m0.309s > sys 0m0.080s > > The combination of these patches thus puts binary uphrade mode almost on par > with a plain dump, which has the potential to make upgrades of large schemas > faster. Parallel-parking this patch with Nathan's in the July CF, just wanted > to type it up while it was fresh in my mind.
Nice! I'll plan on taking a closer look at this one. I have a couple other ideas in-flight (e.g., parallelizing the once-in-each-database operations with libpq's asynchronous APIs) that I'm hoping to post soon, too. v18 should have a lot of good stuff for pg_upgrade... -- Nathan Bossart Amazon Web Services: https://aws.amazon.com
