Re: Vaccum analyze.

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Fernando Lujan" <flujan(at)uol(dot)com(dot)br>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Vaccum analyze.
Date: 2005-03-18 23:38:14
Message-ID: D425483C2C5C9F49B5B7A41F89441547055A0F@postal.corporate.connx.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Search for "pg_autovacuum"

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Fernando Lujan
Sent: Friday, March 18, 2005 3:29 PM
To: pgsql-general(at)postgresql(dot)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

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2005-03-19 00:13:49 Re: Vaccum analyze.
Previous Message Fernando Lujan 2005-03-18 23:28:50 Vaccum analyze.