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 <[EMAIL PROTECTED]> wrote:
Stefan Kaltenbrunner <[EMAIL PROTECTED]> 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