Re: pg_dump order of operation - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump order of operation
Date
Msg-id 19812.1535297050@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump order of operation  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: pg_dump order of operation
List pgsql-general
Ron <ronljohnsonjr@gmail.com> 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.

But what are you thinking constitutes the "dump order" in a parallel dump?

            regards, tom lane


pgsql-general by date:

Previous
From: Raghavendra Rao J S V
Date:
Subject: Re: Size of the table is growing abnormally in my database.
Next
From: Wilhansen Li
Date:
Subject: "cache lookup failed for type ####" when running unit tests