| From: | Doug McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | Peter Choe <choepete(at)mindspring(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: process time of update |
| Date: | 2002-11-26 14:09:11 |
| Message-ID: | m3d6osfmns.fsf@varsoon.wireboard.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Peter Choe <choepete(at)mindspring(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Choe | 2002-11-26 14:12:33 | Re: process time of update |
| Previous Message | Bruno Wolff III | 2002-11-26 14:08:24 | Re: Need help with sql select on null dates! |