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: | Raw Message | Whole Thread | 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 |