Re: process time of update

Peter Choe <choepete@mindspring.com> writes:

> 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?

1) Are you running VACUUM regularly?

2) You are way, way, way out of date.  6.5.3 is at least five years old
   and has known bugs.  You will see a lot of improvements in
   functionality and performance if you upgrade to 7.2.3 or the
   upcoming 7.3 release.

-Doug