Re: pg_upgrade slowness for databases with many tables

Stefan Seifert <nine@detonation.org> writes:
> It looks like LockReassignCurrentOwner is taking most of the time.

Yeah, so that is the issue that was alleviated by the patch you were
pointed to.

> What I really wonder though is, why pg_dump does all these queries for single
> objects in the first place? If the target is to create a complete schema dump,
> why not doing a select * from all the relevant pg_* tables and construct the
> big picture in memory? That surely would be much faster?

It's unclear that it would be faster, and it is clear that restructuring
pg_dump like that would be a lotta work.

            regards, tom lane