JDBC Performance - Mailing list pgsql-novice

From
Subject JDBC Performance
Date
Msg-id Pine.LNX.4.21.0107311540020.31974-100000@mwcs.mb.ca
Whole thread Raw
List pgsql-novice

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-novice by date:

Previous
From: Neal Lindsay
Date:
Subject: Re: Dividing (and rounding) a date?
Next
From: "Lorenzo De Vito"
Date:
Subject: Creating DB