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

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:

Have you vacuumed the DB?

Travis

-----Original Message-----
From: Peter Choe [mailto:choepete@mindspring.com]
Sent: Tuesday, November 26, 2002 7:49 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] process time of update

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

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