| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | David Fetter <david(at)fetter(dot)org> |
| Cc: | Hannu Krosing <hannu(at)2ndQuadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Patch: plan invalidation vs stored procedures |
| Date: | 2008-08-20 01:50:53 |
| Message-ID: | 17481.1219197053@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
David Fetter <david(at)fetter(dot)org> writes:
> On Tue, Aug 19, 2008 at 07:45:16PM -0400, Tom Lane wrote:
>> FWIW, given that there will probably always be corner cases. I can
>> see the attraction in Simon's suggestion of providing a way to
>> manually issue a system-wide forced plan flush.
> Would that require a system-wide plan cache to implement?
No, just a function that can issue a suitable sinval message.
plancache.c would already respond in the desired way to a relcache inval
message with OID = 0, though likely it'll be cleaner to invent an sinval
message type specifically for the purpose.
One thing to think about is whether the flush should be truly
system-wide or just database-wide. I can see a lot more uses for the
latter than the former --- I don't think there's a reason for cached
plans to depend on any contents of the shared catalogs.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Asko Oja | 2008-08-20 01:56:28 | Re: Patch: plan invalidation vs stored procedures |
| Previous Message | ITAGAKI Takahiro | 2008-08-20 01:46:19 | Re: Proposed Resource Manager Changes |