Re: pg_dump order of operation
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 should get more or less the same behavior as in 8.4. If you do use that, then it's hardly surprising that things are more complicated. I'm not demanding that it be simple, but just asking what the pattern is. -- Angular momentum makes the world go 'round.
Re: pg_dump order of operation
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 behavior as in 8.4. If you do use that, then it's hardly surprising that things are more complicated. It looks like there's a hack in there to order tables by decreasing size during a parallel dump, on the theory that we'll get more parallelism that way. (Not sure I believe that, and the part of it that also orders index dumps that way is certainly brain-dead.) regards, tom lane
Re: pg_dump order of operation
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 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. 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. -- Angular momentum makes the world go 'round.
Re: pg_dump order of operation
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 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. Perhaps I don't understand *your* question. What concrete problem are you having? regards, tom lane
Re: pg_dump order of operation
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 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.
Re: pg_dump order of operation
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 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
pg_dump order of operation
Hi, 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? Thanks -- Angular momentum makes the world go 'round.
