Postgres Pro
Downloads
Home   >   mailing lists

Re: JDBC driver build 215 slow when index contains column - Mailing list pgsql-jdbc

From Roland Walter
Subject Re: JDBC driver build 215 slow when index contains column
Date
Msg-id 422EC44A.3050106@mosaic-ag.com
Whole thread Raw
In response to JDBC driver build 215 slow when index contains column of type BIGINT  (Roland Walter <rwa@mosaic-ag.com>)
List pgsql-jdbc
Tree view 
Roland Walter schrieb:

...

>
> I use setLong() to set the value of bc_id, but the update
> is slow, as the index on bigint does not get used.
>
> Changing the JDBC-driver to build 310 increases the speed dramatically:
> 160 updates with build 215 consumed more than 10 minutes, with build 310
> just about 3 seconds.

...

Forgot to mention that the table contains about 1.5 million rows.


--
Roland Walter
MOSAIC SOFTWARE AG
Telefon: 02225/882-411 Fax: 02225/882-201
http://www.mosaic-ag.com

pgsql-jdbc by date:

Previous
From: Roland Walter
Date:
Subject: JDBC driver build 215 slow when index contains column of type BIGINT
Next
From: Oliver Jowett
Date:
Subject: Re: JDBC driver build 215 slow when index contains column