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 19:44:06
Message-ID: 15595.1535312646@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2018-08-26 19:52:27 Re: pg_dump order of operation
Previous Message Ron 2018-08-26 19:26:38 Re: pg_dump order of operation