Re: Re: [BUGS] create index concurrently blocks on transactions in other databases - Mailing list pgsql-patches

From Tom Lane
Subject Re: Re: [BUGS] create index concurrently blocks on transactions in other databases
Date
Msg-id 7945.1189126884@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] create index concurrently blocks on transactions in other databases  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-patches
Simon Riggs <simon@2ndquadrant.com> writes:
> On Thu, 2007-09-06 at 15:55 -0400, Tom Lane wrote:
>> This would have been painful to fix in 8.2 but it seems relatively
>> trivial in HEAD --- we just need another filter option in
>> GetCurrentVirtualXIDs.

> Patch enclosed. Tested manually on same/different databases.
> No docs changed, nor test cases added.

Applied.  I changed the docs thus

-     addition it must wait for all existing transactions to terminate.  Thus
+     addition it must wait for all existing transactions that could potentially
+     use the index to terminate.  Thus

which is a bit vague about the details but perhaps that's just as well.

            regards, tom lane

pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [BUGS] create index concurrently blocks on transactions in other databases
Next
From: Greg Smith
Date:
Subject: Re: HOT patch - version 15