Re: postgres taking longer to update

I've never used this version (6.5.3), but have you tried the 'vacuum'
command?

>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
>
>
>
>

--
Diogo de Oliveira Biazus
diogo(at)ikono(dot)com(dot)br
Ikono Sistemas e Automação
http://www.ikono.com.br