Re: Postgres batch write very slow - what to do

From: femski <hypertree(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres batch write very slow - what to do
Date: 2007-03-15 01:24:36
Message-ID: 9486986.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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(at)yahoo(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2007-03-15 02:26:20 Re: Postgres batch write very slow - what to do
Previous Message Merlin Moncure 2007-03-15 00:52:19 Re: Postgres batch write very slow - what to do