From: | Diogo Biazus <diogo(at)ikono(dot)com(dot)br> |
---|---|
To: | peter <choepete(at)mindspring(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgres taking longer to update |
Date: | 2002-11-26 19:57:09 |
Message-ID: | 3DE3D215.6080302@ikono.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Luc Lachance | 2002-11-26 19:59:15 | Re: Updating table with max from another table |
Previous Message | Jean-Luc Lachance | 2002-11-26 19:41:47 | Re: ALTER TRIGGER DISABLE/ENABLE |