Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C385F9FB407 for ; Wed, 14 Mar 2007 22:24:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 14624-05 for ; Wed, 14 Mar 2007 22:24:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from talk.nabble.com (www.nabble.com [72.21.53.35]) by postgresql.org (Postfix) with ESMTP id 8862C9FB310 for ; Wed, 14 Mar 2007 22:24:37 -0300 (ADT) Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1HReho-0007nH-Ax for pgsql-performance@postgresql.org; Wed, 14 Mar 2007 18:24:36 -0700 Message-ID: <9486986.post@talk.nabble.com> Date: Wed, 14 Mar 2007 18:24:36 -0700 (PDT) From: femski To: pgsql-performance@postgresql.org Subject: Re: Postgres batch write very slow - what to do In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: hypertree@yahoo.com References: <9452092.post@talk.nabble.com> <45F685B7.5040001@enterprisedb.com> <9453712.post@talk.nabble.com> <9473692.post@talk.nabble.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/241 X-Sequence-Number: 23646 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 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.