Re: [HACKERS] CIC and deadlocks

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] CIC and deadlocks
Дата
Msg-id 13046.1205770986@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] CIC and deadlocks  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Список pgsql-patches
"Pavan Deolasee" <pavan.deolasee@gmail.com> writes:
> [ patch to reduce probability of deadlock of CREATE INDEX CONCURRENTLY
>   with other things ]

This patch no longer applies because of the VirtualXid changes.
Looking at it again, I'm fairly dissatisfied with it anyway;
I really don't like moving the GetTransactionSnapshot calls around
like that, because it opens a risk that GetTransactionSnapshot won't
get called at all.

Since the autovacuum case is already dealt with separately, I'm
thinking there is no problem here that we actually need to solve.
C.I.C. can never be guaranteed free of deadlock risk, so I don't
see a lot of value in making it free of deadlock risk against
just CLUSTER and VACUUM FULL.

            regards, tom lane

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Minimum selectivity estimate for LIKE 'prefix%'
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Patch Status