Re: pg_restore -j - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_restore -j
Date
Msg-id 27324.1240440392@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore -j  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pg_restore -j  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Alvaro Herrera wrote:
>> I just noticed (!) that Make accepts an argument-less -j option, which
>> it takes to mean "use as many parallel jobs as possible".

> An unlimited pg_restore -j seems pretty scary.

Yeah.  Even if Make has a sane way to estimate how many jobs it should
use, I'm not sure that pg_restore does.  (The most obvious heuristic
for Make is to try to find out how many CPUs there are --- but at
least it's running on the same machine it's going to be eating CPU
on.  pg_restore can't assume that.)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: pg_restore -j
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_restore -j