Re: pg_dump order of operation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump order of operation
Date: 2018-08-26 15:24:10
Message-ID: 19812.1535297050@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron <ronljohnsonjr(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wilhansen Li 2018-08-26 17:40:19 "cache lookup failed for type ####" when running unit tests
Previous Message Raghavendra Rao J S V 2018-08-26 05:24:55 Re: Size of the table is growing abnormally in my database.