Re: do i need to change the jar in case of new PostgreSQL installation

["surabhi.ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>]

Title: Re: [JDBC] do i need to change the jar in case of new PostgreSQL installation

hi,

i have noticed a drop in the performance in delete operations after I ugraded from Postgres8.0.0 (32 bit server)

to Postgres 8.1.5 (64 bit server)

However I have not ugraded the jdbc jar, I am still using postgresql-8.0-310.jdbc3.jar

I wanted to ak if the drop is because I am still using the old jdbc driver?

 

thanks,

regard

Surabhi

---

From: Heikki Linnakangas [mailto:heikki(at)enterprisedb(dot)com]
Sent: Wed 11/29/2006 9:30 PM
To: surabhi.ahuja
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] do i need to change the jar in case of new PostgreSQL installation

surabhi.ahuja wrote:
>  I have been using Postgres 8.0.0 on my mc
> for which i used the following jar:
>  postgresql-8.0-310.jdbc3.jar
> 
> now i will be going for Postgres8.1.5 , 64 bit server
> 
> Is it ok if I countinue using the same jar?

It should work, though it's usually a good idea to use the latest driver.

> Why i am asking is this: I have noticed a decrease in the databasae operations like delete.

Do you mean that you're getting less performance with a newer JDBC
driver version, doing a delete operation, than with the older 8.0-310
version? Or that you're upgrading you're server to 8.1.5 for better
performance?

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com