Re: JDBC driver build 215 slow when index contains column

From: Roland Walter <rwa(at)mosaic-ag(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC driver build 215 slow when index contains column
Date: 2005-03-09 09:39:22
Message-ID: 422EC44A.3050106@mosaic-ag.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2005-03-09 13:15:27 Re: JDBC driver build 215 slow when index contains column
Previous Message Roland Walter 2005-03-09 09:26:33 JDBC driver build 215 slow when index contains column of type BIGINT