From: Merlin Moncure <mmoncure@gmail.com>
To: femski <hypertree@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres batch write very slow - what to do
Date: Fri, 16 Mar 2007 07:48:22 -0500
Message-ID: <b42b73150703160548t683ee4eckc3b05275e000b02b@mail.gmail.com> (raw)
In-Reply-To: <9492938.post@talk.nabble.com>
References: <9452092.post@talk.nabble.com>
<45F685B7.5040001@enterprisedb.com>
<9453712.post@talk.nabble.com>
<9473692.post@talk.nabble.com>
<b42b73150703141752q64ddebc2mb53c501047d0b7b6@mail.gmail.com>
<9486986.post@talk.nabble.com>
<b42b73150703141926p220b86c3m663f12aabd678d78@mail.gmail.com>
<9492938.post@talk.nabble.com>
On 3/15/07, femski <hypertree@yahoo.com> wrote:
>
> I tried maxpages = 0 and full_page_writes=off and it seemed to be taking
> forever.
> All other tricks I have already tried.
>
> At this point I wondering if its a jdbc client side issue - I am using the
> latest 8.1.
> (as I said in an earlier post - I am using addBatch with batch size of 100).
> But just in case - I am missing something.
>
> If 17k record/sec is right around expected then I must say I am little
> disappointed from the "most advanced open source database".
Be careful...you are just testing one very specific thing and it its
extremely possible that the Oracle JDBC batch insert is more optimized
than PostgreSQL's. On my little pentium 4 workstation, by inserting
10 rows per insert:
insert values ([...]), ([...]), [8 more rows];
I got a 5x speedup in insert performance using this feature (which is
unfortunately new for 8.2). Oracle is most likely pulling similar
tricks inside the driver. PostgreSQL is much faster than you think...
merlin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mmoncure@gmail.com, hypertree@yahoo.com
Subject: Re: Postgres batch write very slow - what to do
In-Reply-To: <b42b73150703160548t683ee4eckc3b05275e000b02b@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox