i am upgrading the version soon, but i still need this one running until i
have the new server set up.
i thought i was running VACUUM regularly, but i need to check it again.
thanks for the help.
At 09:09 AM 11/26/2002, Doug McNaught wrote:
>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