Storing a query plan...

Поиск
Список
Период
Сортировка
От Katsaros Kwn/nos
Тема Storing a query plan...
Дата
Msg-id 1093972679.8691.8.camel@localhost.localdomain
обсуждение исходный текст
Ответы Re: Storing a query plan...  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
Hi!

I'm new to PostgreSQL (and C) and what I'm trying to do is to store a
query plan on disc (in a binary file).
My approach is to use SPI functions to get the query plan and then
transform it into a 'storable' format (Replacing the pointers with
actual values).

Is there any other way to do this? Is my approach OK?
The sure thing is that it is a messy task!

I posted this message to the 'general' and 'novice' lists but the only
answer I got was from the latter:
       " I'd look at extending the outfuncs/readfuncs code to deal with       all the node types used in plan trees,
andthen store text       strings instead of binary.              regards, tom lane",
 

which seems a little confusing to me since as I said I'm a newbie.

Thanks in advance,
ntinoas 






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

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Storing a query plan...