>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
Tom> But really this is a special case of the problem of "schema
Tom> changed underneath a plan", and yes it'd be nice to notice
Tom> that and invalidate the plan.
In general, pgsql doesn't cache access plans, correct ?
If there was a cache of access plans, repeated queries (not just
prepared by the same client) could use the same plan avoiding
recompilation. The cache will also be a single place in shared memory
where invalidation can take place.
Just my 2c.
In response to
pgsql-hackers by date
|Next:||From: Sumaira Ali -||Date: 2003-04-28 05:25:44|
|Subject: LockData (Lock.h)|
|Previous:||From: Tom Lane||Date: 2003-04-28 04:57:10|
|Subject: Re: Prepared queries and ANALYZE |