Re: Prepared queries and ANALYZE
От
Sailesh Krishnamurthy
Тема
Re: Prepared queries and ANALYZE
Дата
Msg-id
bxyllxvmd0x.fsf@datafix.CS.Berkeley.EDU
Ответ на
Re: Prepared queries and ANALYZE (Tom Lane)
Список
Дерево обсуждения
Prepared queries and ANALYZE Gavin Sherry <swm@linuxworld.com.au>
Re: Prepared queries and ANALYZE Tom Lane <tgl@sss.pgh.pa.us>
Re: Prepared queries and ANALYZE Sailesh Krishnamurthy <sailesh@cs.berkeley.edu>
Re: Prepared queries and ANALYZE Gavin Sherry <swm@linuxworld.com.au>
>>>>> "Tom" == Tom Lane 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. -- Pip-pip Sailesh http://www.cs.berkeley.edu/~sailesh
В списке pgsql-hackers по дате отправления
