Re: [DOC] Document concurrent index builds waiting on each other

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [DOC] Document concurrent index builds waiting on each other
Дата
Msg-id 20201130215255.GA4219@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: [DOC] Document concurrent index builds waiting on each other  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: [DOC] Document concurrent index builds waiting on each other  (James Coleman <jtc331@gmail.com>)
Список pgsql-hackers
On 2020-Sep-30, Michael Paquier wrote:

> +  <para>
> +   <command>CREATE INDEX</command> (including the <literal>CONCURRENTLY</literal>
> +   option) commands are included when <command>VACUUM</command> calculates what
> +   dead tuples are safe to remove even on tables other than the one being indexed.
> +  </para>
> FWIW, this is true as well for REINDEX CONCURRENTLY because both use
> the same code paths for index builds and validation, with basically
> the same waiting phases.  But is CREATE INDEX the correct place for
> that?  Wouldn't it be better to tell about such things on the VACUUM
> doc?

Yeah, I think it might be more sensible to document this in
maintenance.sgml, as part of the paragraph that discusses removing
tuples "to save space".  But making it inline with the rest of the flow,
it seems to distract from higher-level considerations, so I suggest to
make it a footnote instead.

I'm not sure on the wording to use; what about this?


Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: support IncrementalSortPath type in outNode()
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal: unescape_text function