| From: | "Katsaros Kwn/nos" <ntinos(at)aueb(dot)gr> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Storing a query plan... |
| Date: | 2004-08-31 17:17:59 |
| Message-ID: | 1093972679.8691.8.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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, and then 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2004-08-31 17:28:12 | Re: Storing a query plan... |
| Previous Message | Fabien COELHO | 2004-08-31 15:01:19 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |