Re: pg_restore -j - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: pg_restore -j
Date
Msg-id 20090423012738.GJ8123@tamriel.snowman.net
Whole thread Raw
In response to Re: pg_restore -j  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> 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.)

I'm not sure if I'd consider it 'sane', but make basically uses the
dependency information, if a job can be run based on its dependency
requirements, then it's started.  For small projects, this isn't
necessairly terrible, but it's not something I would generally
recommend.

I don't see any reasonable implementation, or justification, for
supporting something like that in pg_restore.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Prepared transactions vs novice DBAs, again
Next
From: Robert Haas
Date:
Subject: Re: Prepared transactions vs novice DBAs, again