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 16055.1133901688@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:
> Is it possible to release a lock without commit ?

Yes, but I don't see where that helps you here.

(To do any of this, you'd need to use the same kluge VACUUM does to hold
selected locks across a series of transactions.  So in reality you'd
probably be thinking of committing a startup transaction and letting
some of the locks be released by that.)
        regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Concurrent CREATE INDEX, try 2 (was Re: Reducing relation locking overhead)
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Concurrent CREATE INDEX, try 2 (was Re: Reducing