Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres batch write very slow - what to do - Mailing list pgsql-performance

From femski
Subject Re: Postgres batch write very slow - what to do
Date
Msg-id 9486986.post@talk.nabble.com
Whole thread Raw
In response to Re: Postgres batch write very slow - what to do  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: Postgres batch write very slow - what to do  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-performance
Tree view 
I am using Oracle XE so its using only one core and doing just fine.
How do I split backend to 4+ processes ?
I don't want to write a multithreaded loader app.
And I didn't think Postgres can utilize multiple cores for the
same insert statement.

thanks,

-Sanjay


On 3/14/07, femski <hypertree@yahoo.com> wrote:

when loading to oracle, does it utilize more than one core? istm your
best bet would be to split load process to 4+ backends...

merlin


--
View this message in context: http://www.nabble.com/Postgres-batch-write-very-slow---what-to-do-tf3395195.html#a9486986
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Postgres batch write very slow - what to do
Next
From: "Merlin Moncure"
Date:
Subject: Re: Postgres batch write very slow - what to do