| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Re: [BUGS] create index concurrently blocks on transactions in other databases |
| Date: | 2007-09-07 01:01:24 |
| Message-ID: | 7945.1189126884@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-patches |
Simon Riggs <simon(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-09-07 02:07:06 | Re: hu_HU.UTF8 case insensitive search fail to return values |
| Previous Message | Simon Riggs | 2007-09-06 21:55:27 | Re: [BUGS] create index concurrently blocks on transactions in other databases |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2007-09-07 04:35:06 | Re: HOT patch - version 15 |
| Previous Message | Simon Riggs | 2007-09-06 21:55:27 | Re: [BUGS] create index concurrently blocks on transactions in other databases |