Plan caching and serialization for reuse across executions

Поиск
Список
Период
Сортировка
От Xuan Chen
Тема Plan caching and serialization for reuse across executions
Дата
Msg-id tencent_C575540808B79A0BEB25F343724F6697C80A@qq.com
обсуждение исходный текст
Ответы Re: Plan caching and serialization for reuse across executions
Re: Plan caching and serialization for reuse across executions
Список pgsql-hackers
Hi hackers,

I am currently exploring whether it is possible to cache a plan generated by the PostgreSQL planner and reuse it across
laterexecutions. 

I understand that there are existing mechanisms like PREPARE/EXECUTE and CachedPlan in plancache.c, but these are tied
toprepared statements and session-level usage. My interest is more on the research side:  

- Is there any supported (or experimental) way to serialize a Plan or PlannedStmt structure and reload it in a future
execution,bypassing the planner? 
- If not, would it make sense to extend the existing CachedPlan mechanism to support serialization/deserialization, or
arethere known architectural reasons why this approach is discouraged? 
- Any relevant references in the source code (planner, plancache.c, executor) that I should study would be very
helpful.

The motivation is research-oriented: I want to experiment with plan persistence as a way to reduce planning overhead
andstudy trade-offs of reusing cached plans. 

Thanks a lot for your guidance!

Best regards,
Xuan Chen

В списке pgsql-hackers по дате отправления: