Re: Patch: plan invalidation vs stored procedures
David Fetter <david@fetter.org>
From: David Fetter <david@fetter.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Hannu Krosing <hannu@2ndQuadrant.com>,
Robert Haas <robertmhaas@gmail.com>, Dimitri Fontaine <dfontaine@hi-media.com>, pgsql-hackers@postgresql.org, Zdenek Kotala <Zdenek.Kotala@Sun.COM>
Date: 2008-08-20T02:28:54Z
Lists: pgsql-hackers
On Tue, Aug 19, 2008 at 09:50:53PM -0400, Tom Lane wrote: > David Fetter <david@fetter.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. They might during an on-line upgrade. Zdenek? Cheers, David. -- David Fetter <david@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate