Re: why postgresql over other RDBMS - Mailing list pgsql-general

From Tom Lane
Subject Re: why postgresql over other RDBMS
Date
Msg-id 3692.1180196259@sss.pgh.pa.us
Whole thread Raw
In response to Re: why postgresql over other RDBMS  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Responses Re: why postgresql over other RDBMS
Re: why postgresql over other RDBMS
List pgsql-general
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

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: backup strategies
Next
From: "Richard P. Welty"
Date:
Subject: Re: backup strategies