Re: process time of update

Have you vacuumed the DB?

Travis

-----Original Message-----
From: Peter Choe [mailto:choepete(at)mindspring(dot)com]
Sent: Tuesday, November 26, 2002 7:49 AM
To: pgsql-general(at)postgresql(dot)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