On Fri, 18 Mar 2005 20:28:50 -0300, Fernando Lujan <flujan@uol.com.br> wrote:
> Hi folks,
>
> I wanna know from you, how often must I run vaccum analyze on my db?
>
> Once per day, twice... One per hour and so on...
>
> I didn't find a especific document about this question.

That's because it depends on how you are using the database. In
general, running it once/day is a minimum safe assumption. However,
if the data is changing really quickly, then you should run it more
frequently. The only way to judge is to run it and see how much work
is being done each time.


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org

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