Re: Patch that deals with that AtCommit_Portals encounters - Mailing list pgsql-patches

From Thomas Hallgren
Subject Re: Patch that deals with that AtCommit_Portals encounters
Date
Msg-id thhal-0svBdA1+yyicCmX0AvF9AjGzG00YaBe@mailblocks.com
Whole thread Raw
In response to Re: Patch that deals with that AtCommit_Portals encounters  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tom Lane wrote:

>Bruce Momjian <pgman@candle.pha.pa.us> writes:
>
>
>>>This patch will ensure that the hash table iteration performed by
>>>AtCommit_Portals is restarted when a portal is deleted.
>>>
>>>
>
>
>
>>I have applied the following patch.  I assume it is too risky for
>>backpatch to 8.0.X.
>>
>>
>
>I don't think it's appropriate in HEAD either --- it doesn't solve the
>problem, and it is an expensive way of not doing so :-(
>
>
It certanly solves my problem! And as for expensive? Why would it be? It
just restarts the iteration everytime something is removed. The only
thing that could make this patch consume CPU cycles is if there's a vast
amount of Portals in the iteration that are not candidates for removal.
I don't see that happen. Do you?

Regards,
Thomas Hallgren



pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Patch that deals with that AtCommit_Portals encounters
Next
From: Andrew Dunstan
Date:
Subject: Re: [HACKERS] plperl and pltcl installcheck targets