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