Tom Lane wrote:
Bruce Momjian <pgman@candle.pha.pa.us> writes: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?
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 :-(
Regards, Thomas Hallgren
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq