"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> I think a sane way to think about what Simon would like to accomplish
> is not "turn psql into a parallel job scheduler" but "teach pg_restore
> how to do parallel scheduling, and then see if it can be made to do
> anything useful with plain-text instead of archive-dump input".
> At least that way you're talking about something that's within the scope
> of the program's purpose.
Er, yes, that's what I meant. My point though was just that for single
commands which take a long time to run on the server there's no additional
work in the client needed to handle it. That is, as opposed to handling
multiple COPYs in parallel where psql has to be involved in the actual data
transfer and so you need multiple client as well as server processes.
I think I'm sorry I got involved here though since I specifically do not have
either the full context of this discussion or any background in
Ask me about EnterpriseDB's PostGIS support!
In response to
pgsql-hackers by date
|Next:||From: Brendan Jurd||Date: 2008-02-27 02:05:44|
|Subject: Re: One more option for pg_dump...|
|Previous:||From: Peter Eisentraut||Date: 2008-02-27 00:50:08|
|Subject: Re: Required make version|