Postgres Pro
Downloads
Home   >   mailing lists

process time of update - Mailing list pgsql-general

From Peter Choe
Subject process time of update
Date
Msg-id 5.0.0.25.0.20021126084801.02a9d840@pop.mindspring.com
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jeff Sacksteder
Date:
Subject: Need help with sql select on null dates!
Next
From: "Henshall, Stuart - Design & Print"
Date:
Subject: Re: Need help with sql select on null dates!