Re: Prepared queries and ANALYZE

>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.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
niceto 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.

-- 
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh