On Fri, 18 Mar 2005 20:28:50 -0300, Fernando Lujan <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
