Postgres Pro
Downloads
Home   >   mailing lists

JDBC Performance - Mailing list pgsql-jdbc

From
Subject JDBC Performance
Date
Msg-id Pine.LNX.4.21.0107311451440.31928-100000@mwcs.mb.ca
Whole thread Raw
Responses RE: JDBC Performance  ("Dave Cramer" <Dave@micro-automation.net>)
List pgsql-jdbc
Tree view 
I am having some performance problems with postgresql and JDBC when it
comes to updates.  If I try and update a record it seems to be taking 1.7
seconds for 100 records or 14 seconds for 500 records.  An insert is only
taking between 3-5 ms/record.  Performance on the updates continue to
decrease until I vacuum analyze the database again.  Is this normal?

Mike

pgsql-jdbc by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: [HACKERS] Re: What needs to be done?
Next
From: Vince Vielhaber
Date:
Subject: Re: Re: What needs to be done?