Re: invalidating cached plans

Harald Fuchs <use_reply_to(at)protecting(dot)net> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>> One possible approach is to do the invalidation on a sufficiently coarse
>> grain that we don't care. For example, I would be inclined to make any
>> change in a table's schema invalidate all plans that use that table at
>> all; that would then subsume the constraint problem for instance. This
>> doesn't solve the inlined function problem however.

> How about making this even more coarse-grained? Blindly throw all
> cached plans away when something in the database DDL changes.

Well, the problem is not so much that we can't tell what depends on
which, as that we have no mechanism to make plan invalidation happen
in the first place. I don't think that "throw everything away" will
make it very much simpler.

regards, tom lane