Skip site navigation (1) Skip section navigation (2)

Re: performance for high-volume log insertion

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: Thomas Kellerer <spam_eater(at)gmx(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: performance for high-volume log insertion
Date: 2009-04-27 06:29:19
Message-ID: dcc563d10904262329k4c2e4a01p6fb7e684130f8df5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Sun, Apr 26, 2009 at 11:07 AM, Kris Jurka <books(at)ejurka(dot)com> wrote:
>
>
> On Thu, 23 Apr 2009, Thomas Kellerer wrote:
>
>> Out of curiosity I did some tests through JDBC.
>>
>> Using a single-column (integer) table, re-using a prepared statement took
>> about 7 seconds to insert 100000 rows with JDBC's batch interface and a
>> batch size of 1000
>>
>
> As a note for non-JDBC users, the JDBC driver's batch interface allows
> executing multiple statements in a single network roundtrip.  This is
> something you can't get in libpq, so beware of this for comparison's sake.

Really?  I thought that executing statements like so:

select * from a;insert ...;delete;

in psql / libpq would execute them all in one trip.

In response to

Responses

pgsql-performance by date

Next:From: Kris JurkaDate: 2009-04-27 06:45:08
Subject: Re: performance for high-volume log insertion
Previous:From: Mark WongDate: 2009-04-27 03:44:51
Subject: Re: Using IOZone to simulate DB access patterns

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group