Re: Vaccum analyze.

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