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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [DOC] Document concurrent index builds waiting on each other
Дата
Msg-id 1337019.1610573371@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [DOC] Document concurrent index builds waiting on each other  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: [DOC] Document concurrent index builds waiting on each other  (James Coleman <jtc331@gmail.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> On 2021-Jan-13, James Coleman wrote:
>>>> This is true.  So I propose
>>>> Like any long-running transaction, <command>REINDEX</command> can
>>>> affect which tuples can be removed by concurrent <command>VACUUM</command>
>>>> on any table.

>> Looks like what got committed is "REINDEX on a table" not "on any",
>> but I'm not sure that matters too much.

> Ouch.  The difference seems slight enough that it doesn't matter; is it
> ungrammatical?

I'd personally have written "on other tables" or "on another table",
or left out that clause altogether and just said "concurrent
<command>VACUUM</command>".  I'm not sure it's ungrammatical exactly,
but the antecedent of "a table" is a bit unclear; people might
wonder if it means the table being reindexed.

            regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Executing inet_server_addr/port() in parallel workers
Следующее
От: James Coleman
Дата:
Сообщение: Re: [DOC] Document concurrent index builds waiting on each other