Re: invalidating cached plans - Mailing list pgsql-hackers

From Harald Fuchs
Subject Re: invalidating cached plans
Date
Msg-id puvf7u9xrs.fsf@srv.protecting.net
Whole thread Raw
In response to invalidating cached plans  (Neil Conway <neilc@samurai.com>)
Responses Re: invalidating cached plans
List pgsql-hackers
In article <6028.1110785150@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.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.



pgsql-hackers by date:

Previous
From: Miroslav Šulc
Date:
Subject: Re: [PERFORM] How to read query plan
Next
From: Miroslav Šulc
Date:
Subject: Re: [PERFORM] How to read query plan