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
pgsql-performance by date
|Next:||From: Kris Jurka||Date: 2009-04-27 06:45:08|
|Subject: Re: performance for high-volume log insertion|
|Previous:||From: Mark Wong||Date: 2009-04-27 03:44:51|
|Subject: Re: Using IOZone to simulate DB access patterns|