Doug McNaught <doug@mcnaught.org> writes:
> 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.
> 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
