Alvaro Herrera <alvherre@commandprompt.com> writes:
> This is where the interesting questions are:
> http://archives.postgresql.org/message-id/10333.1219179364%40sss.pgh.pa.us
Upthread, someone speculated about solving the problem by forcing plan
cache flush on *any* catalog change. I think that's probably not
acceptable from an efficiency standpoint. But maybe it'd be a good idea
to special-case common cases and fall back to a stupid flush for less
common cases, rather than invest all the work that'd be needed to track
every direct and indirect dependency of every plan. My first thought
along these lines is:
* track table dependencies exactly (important for efficiency, plus we've got the code already)
* track function dependencies exactly (seems function definitions might change often enough to make it important for
efficiency;maybe only track PL function dependencies??)
* brute-force flush for any other catalog change that could affect plans
However I have no hard evidence to back up drawing the line there rather
than somewhere else. Anyone have data on what sort of DDL changes are
common in their applications?
regards, tom lane