Re: Add SKIP LOCKED to VACUUM and ANALYZE

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Add SKIP LOCKED to VACUUM and ANALYZE
Дата
Msg-id 20181004000911.GJ2609@paquier.xyz
обсуждение исходный текст
Ответ на Re: Add SKIP LOCKED to VACUUM and ANALYZE  ("Bossart, Nathan" <bossartn@amazon.com>)
Ответы Re: Add SKIP LOCKED to VACUUM and ANALYZE
Список pgsql-hackers
On Wed, Oct 03, 2018 at 04:20:42PM +0000, Bossart, Nathan wrote:
> Here is what I have so far for the docs:
>
> [snip]

Thanks, I have committed the patch, after minor tweaks to the docs.
Mainly, in the VACUUM page, I have added a mention that VACUUM ANALYZE
can block for row sampling.  I have also removed for now the set of
recommendations the patch added, as we still gather statistics on the
partitioned tables from the row samples gathered from the partitions, so
recommending to list only the leaves is not completely correct either
all the time.

We could perhaps add something about such recommendations.  A separate
section covering more general things may be interesting.
--
Michael

Вложения

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

Предыдущее
От: Daniel Wood
Дата:
Сообщение: Re: Skylake-S warning
Следующее
От: Vik Fearing
Дата:
Сообщение: Re: [RFC] Removing "magic" oids