Re: Clarification required: autovacuum and VACUUM command mode

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Clarification required: autovacuum and VACUUM command mode
Дата
Msg-id AANLkTikFaAvh2jGG909eJJjY424tJPr6SgmNt5cF6g9i@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Clarification required: autovacuum and VACUUM command mode  ("Narasimha Murthy-VRFX87" <VRFX87@motorola.com>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: "Narasimha Murthy-VRFX87"
Дата:
Сообщение: Re: Clarification required: autovacuum and VACUUM command mode
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Clarification required: autovacuum and VACUUM command mode