On 08/26/2018 10:24 AM, Tom Lane wrote:
Ron <ronljohnsonjr@xxxxxxxxx> writes:
In v8.4, I noticed that the tables seemed to be dumped in alphabetical
order. Not so much, though, in a multithreaded 9.6 dump of an 8.4 database;
there's no pattern that I can discern.
In what order does the 9.6 pg_dump dump tables?
I don't believe the ordering rules have changed materially since 8.4;
it's intended to be by object kind, and within that by name, except
where dependencies force doing something else.
I thought that didn't matter, since FK and PK constraints were added (in the
required order) after all data was loaded).
But what are you thinking constitutes the "dump order" in a parallel dump?
I don't understand your question.
--
Angular momentum makes the world go 'round.
