Re: Batch updates and inserts - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Batch updates and inserts
Date
Msg-id Pine.BSO.4.56.0505091250220.5342@leary.csoft.net
Whole thread Raw
In response to Batch updates and inserts  ("Igor Postelnik" <Igor_Postelnik@messageone.com>)
List pgsql-jdbc

On Mon, 9 May 2005, Igor Postelnik wrote:

> What combination of JDBC driver and backend do I need to have support
> for addBatch/executeBatch? What's a reasonable limit for number of
> statements in a batch - either by number of rows or total size?
>

Batch statements have been available in the driver for some time, but the
8.0 driver is the first driver to actually perform them in a batch
fashion.  It requires at least a 7.4 server to take advantage of this.
Size doesn't really matter because the driver itself will internally run
things in batches of 256 statements at a time.

Kris Jurka


pgsql-jdbc by date:

Previous
From: "Igor Postelnik"
Date:
Subject: Batch updates and inserts
Next
From: Euler Taveira de Oliveira
Date:
Subject: Translation update: pt_BR