| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Need some clarification |
| Date: | 2006-05-13 04:57:05 |
| Message-ID: | 26569.1147496225@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Hallgren | 2006-05-13 06:33:14 | Re: Inheritance, Primary Keys and Foreign Keys |
| Previous Message | spaminos-sql | 2006-05-13 02:15:02 | Re: [GENERAL] Querying libpq compile time options |