Re: Concurrent CREATE INDEX, try 2 (was Re: Reducing relation locking overhead)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Concurrent CREATE INDEX, try 2 (was Re: Reducing relation locking overhead)
Дата
Msg-id 16021.1133901518@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Concurrent CREATE INDEX, try 2 (was Re: Reducing  (Hannu Krosing <hannu@skype.net>)
Ответы Re: Concurrent CREATE INDEX, try 2 (was Re: Reducing  (Hannu Krosing <hannu@skype.net>)
Список pgsql-hackers
Дерево обсуждения 
Hannu Krosing <hannu@skype.net> writes:
> What I have in mind would be something like this to get both SNAP2 and
> commit between any transactions:

> LOOP:
>     LOCK AGAINST STARTING NEW TRANSACTIONS

I can hardly credit that "let's block startup of ALL new transactions"
is a more desirable restriction than "let's block writers to the table
we wish to reindex".
        regards, tom lane

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Slow email caught in the act
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Concurrent CREATE INDEX, try 2 (was Re: Reducing relation locking overhead)