Re: Clarification required: autovacuum and VACUUM command mode

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Narasimha Murthy-VRFX87 <VRFX87(at)motorola(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Clarification required: autovacuum and VACUUM command mode
Date: 2010-05-14 14:44:02
Message-ID: AANLkTikFaAvh2jGG909eJJjY424tJPr6SgmNt5cF6g9i@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, May 14, 2010 at 8:20 AM, Narasimha Murthy-VRFX87
<VRFX87(at)motorola(dot)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 option to 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?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Marc G. Fournier 2010-05-14 14:44:38 Re: List traffic
Previous Message Marc G. Fournier 2010-05-14 14:42:09 Re: List traffic