Re: pg_dump order of operation

2018-08-26 Thread Ron
On 08/26/2018 02:44 PM, Tom Lane wrote: Ron writes: On 08/26/2018 01:42 PM, Tom Lane wrote: Perhaps I don't understand *your* question. What concrete problem are you having? I want to track the progress of pg_dump so as to estimate completion time. Well, if you don't use --jobs then you sho

Re: pg_dump order of operation

2018-08-26 Thread Tom Lane
Ron writes: > On 08/26/2018 01:42 PM, Tom Lane wrote: >> Perhaps I don't understand *your* question. What concrete problem are you >> having? > I want to track the progress of pg_dump so as to estimate completion time. Well, if you don't use --jobs then you should get more or less the same beha

Re: pg_dump order of operation

2018-08-26 Thread Ron
On 08/26/2018 01:42 PM, Tom Lane wrote: Ron writes: On 08/26/2018 10:24 AM, Tom Lane wrote: Ron writes: 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

Re: pg_dump order of operation

2018-08-26 Thread Tom Lane
Ron writes: > On 08/26/2018 10:24 AM, Tom Lane wrote: >> Ron writes: >>> 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 doi

Re: pg_dump order of operation

2018-08-26 Thread Ron
On 08/26/2018 10:24 AM, Tom Lane wrote: Ron 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

Re: pg_dump order of operation

2018-08-26 Thread Tom Lane
Ron 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