Storing a query plan... - Mailing list pgsql-hackers

From Katsaros Kwn/nos
Subject Storing a query plan...
Date
Msg-id 1093972679.8691.8.camel@localhost.localdomain
Whole thread Raw
Responses Re: Storing a query plan...  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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 by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Storing a query plan...