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

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

From
"surabhi.ahuja"
Date:
 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?
Why i am asking is this: I have noticed a decrease in the databasae operations like delete.
Please help me in this regards
 
 
thanks,
surabhi
 

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

From
"Heikki Linnakangas"
Date:
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

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

From
"surabhi.ahuja"
Date:
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@enterprisedb.com]
Sent: Wed 11/29/2006 9:30 PM
To: surabhi.ahuja
Cc: pgsql-jdbc@postgresql.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