Re: VACUUM ANALYZE is faster than ANALYZE?

Поиск
Список
Период
Сортировка
От Nicolas Barbier
Тема Re: VACUUM ANALYZE is faster than ANALYZE?
Дата
Msg-id CAP-rdTZRDc4P4Zg=+U-Ct68S5V6ri=EeFv3HSVc8TSVgRQMA=g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: VACUUM ANALYZE is faster than ANALYZE?  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: VACUUM ANALYZE is faster than ANALYZE?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
2012/2/22 Robert Haas <robertmhaas@gmail.com>:

> On Tue, Feb 21, 2012 at 9:00 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>
>> I had to reply to query about usage VACUUM ANALYZE or ANALYZE. I
>> expected so ANALYZE should be faster then VACUUM ANALYZE.
>>
>> But is not true. Why?
>
> I'm pretty sure that VACUUM ANALYZE *will* be faster than ANALYZE in
> general, because VACUUM has to scan the whole table, and ANALYZE only
> a fixed-size subset of its pages.

It sounds like you just said the opposite of what you wanted to say.

Nicolas

-- 
A. Because it breaks the logical sequence of discussion.
Q. Why is top posting bad?


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: VACUUM ANALYZE is faster than ANALYZE?
Следующее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: temporal algebra and data type