Thread: Vaccum analyze.

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.

Thanks in advance.

Fernando Lujan

Search for "pg_autovacuum"

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Fernando Lujan
Sent: Friday, March 18, 2005 3:29 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Vaccum analyze.

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.

Thanks in advance.

Fernando Lujan

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if
your
      joining column's datatypes do not match

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