Re: doc fixes: vacuum_cleanup_index_scale_factor

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: doc fixes: vacuum_cleanup_index_scale_factor
Дата
Msg-id 20180508110542.GJ5192@telsasoft.com
обсуждение исходный текст
Ответ на Re: doc fixes: vacuum_cleanup_index_scale_factor  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Ответы Re: doc fixes: vacuum_cleanup_index_scale_factor  (Liudmila Mantrova <l.mantrova@postgrespro.ru>)
Список pgsql-hackers
3rd iteration ; thanks for bearing with me.

On Tue, May 08, 2018 at 12:35:00PM +0300, Alexander Korotkov wrote:
> Hi, Justin!
> 
> Thank you for revising documentation patch.
> 
> On Mon, May 7, 2018 at 7:55 PM, Justin Pryzby <pryzby@telsasoft.com> wrote:


+        In order to detect stale index statistics, the number of total heap
+        tuples during previous statistics collection is stored in the index
+        meta-page.

Consider removing: "during previous statistics collection"
Or: "during THE previous statistics collection"

+ Once the number of inserted tuples since previous

since THE previous

+        statistics collection is more than
+        <varname>vacuum_cleanup_index_scale_factor</varname> fraction of

Since the multiplier can be greater than 1, should we say "multiple" instead of
fraction?

+        during <command>VACUUM</command> cycle.  Thus, skipping of the B-tree
+        index scan during cleanup stage is only possible when second and
+        subsequent <command>VACUUM</command> cycles detecting no dead tuples.

Change "detecting" to "detect".  Or maybe just "find"

Justin


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors
Следующее
От: Andrew Gierth
Дата:
Сообщение: Re: Bug Report: Error caused due to wrong ordering of filters