postgres taking longer to update

From: choepete(at)mindspring(dot)com (peter)
To: pgsql-general(at)postgresql(dot)org
Subject: postgres taking longer to update
Date: 2002-11-26 13:23:46
Message-ID: 8317cb71.0211260523.61d15a0e@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i have a postgres database (version 6.5.3) that gets update by a Java
program every night.

it seems that each time the update is done it always takes a bit
longer to complete the process. when it first started it took about 2
minutes. now it takes about 2 hours to do the update. is there
something i can do to bring down the time it takes to update the
database?

Peter Choe

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Sacksteder 2002-11-26 13:47:02 Need help with sql select on null dates!
Previous Message Richard Huxton 2002-11-26 13:03:35 Re: the "SORT" late very much.