Postgres Pro
Downloads
Home   >   mailing lists

Re: Clarification required: autovacuum and VACUUM command mode - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Clarification required: autovacuum and VACUUM command mode
Date
Msg-id AANLkTikFaAvh2jGG909eJJjY424tJPr6SgmNt5cF6g9i@mail.gmail.com
Whole thread Raw
In response to Re: Clarification required: autovacuum and VACUUM command mode  ("Narasimha Murthy-VRFX87" <VRFX87@motorola.com>)
List pgsql-admin
Tree view 
On Fri, May 14, 2010 at 8:20 AM, Narasimha Murthy-VRFX87
<VRFX87@motorola.com> wrote:
> Hi Kevin,
>
> Thanks for the clarification.
>
> I have planned to schedule Lazy Vacuum (, not FULL Vacuum) using auto-vacuum daemon.
>
> Another query: I do not want to run Analyze. However, auto-vacuum runs both both VACUUM and ANALYZE. I do not see any
optionto disable running ANALYZE during auto-vacuum. Is there any way to achive this? 

Why would you NOT want to analyze?  Are you considering doing your own
analyzes at the end of a series of updates?

pgsql-admin by date:

Previous
From: "Narasimha Murthy-VRFX87"
Date:
Subject: Re: Clarification required: autovacuum and VACUUM command mode
Next
From: "Kevin Grittner"
Date:
Subject: Re: Clarification required: autovacuum and VACUUM command mode