is the host base configuration methodology in postgres superior to other RDBMS.
is this something novel that postgres has come up with?
~Harpreet
On 5/26/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:Stefan Kaltenbrunner < stefan@kaltenbrunner.cc> writes:
> Tom Lane wrote:
>> A more interesting question is what sort of hardware you need for that
>> actually to be a win, though. Loading a few tables in parallel sounds
>> like an ideal recipe for oversaturating your disk bandwidth...
> you don't actually need that much of disk bandwidth both COPY and CREATE
> INDEX are CPU bottlenecked on modern boxes and reasonable disk
> subsystems - spreading their work over multiple cores/processes can give
> big benefits.
Hmm ... I wonder if that's true for COPY BINARY ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster