| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Doug McNaught <doug(at)mcnaught(dot)org> |
| Cc: | Peter Choe <choepete(at)mindspring(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: process time of update |
| Date: | 2002-11-27 02:08:24 |
| Message-ID: | 12959.1038362904@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Doug McNaught <doug(at)mcnaught(dot)org> writes:
> 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.
> 1) Are you running VACUUM regularly?
If vacuum doesn't help, try dropping and recreating the indexes on the
most-updated tables.
> 2) You are way, way, way out of date.
Indeed.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Wheeler | 2002-11-27 02:35:08 | Re: [HACKERS] Request from eWeek for 7.3 comments |
| Previous Message | Bruce Momjian | 2002-11-27 01:27:29 | Re: postgres taking longer to update |