Storing a query plan...

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

Responses

Browse pgsql-hackers by date

  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