Re: [HACKERS] CIC and deadlocks - Mailing list pgsql-patches

From Tom Lane
Subject Re: [HACKERS] CIC and deadlocks
Date
Msg-id 13046.1205770986@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] CIC and deadlocks  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Minimum selectivity estimate for LIKE 'prefix%'
Next
From: Bruce Momjian
Date:
Subject: Re: Patch Status