Re: Need some clarification - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Need some clarification
Date
Msg-id 26569.1147496225@sss.pgh.pa.us
Whole thread Raw
In response to Re: Need some clarification  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
List pgsql-hackers
"Qingqing Zhou" <zhouqq@cs.toronto.edu> writes:
> Yes, IMHO the basic idea is like that - the difficulty is that we are 
> lack of efficient object tracking mechanism, so that when an underlying 
> object is changed, all the prepared plans should be invalidated.

The basic signaling mechanism does exist (the "sinval" code for tracking
catcache invalidations).  What needs to be done is setting up some
infrastructure for storing plans and recognizing that a particular plan
is invalidated by a particular sinval message.  I think Neil's done some
work on this.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: Need some clarification
Next
From: Thomas Hallgren
Date:
Subject: Re: Inheritance, Primary Keys and Foreign Keys