Re: Want to use my own query-plan - Mailing list pgsql-hackers

From Neil Conway
Subject Re: Want to use my own query-plan
Date
Msg-id 1161393052.5190.11.camel@localhost.localdomain
Whole thread Raw
In response to Want to use my own query-plan  (dakotali kasap <dakotalidavid@yahoo.com>)
List pgsql-hackers
On Fri, 2006-10-20 at 16:05 -0700, dakotali kasap wrote:
> 1. How can I prepare my own query plan?

You can't: there is currently no public API for constructing plans by
hand. You could kludge something up by hand, but it would be pretty
fragile (internal planner data structures may well change between
releases).

> 2. How can I make postgresql execute my own query plan?

Once you have a valid Plan, you can just feed it to the executor as
normal (CreateQueryDesc(), ExecutorStart(), ExecutorRun(),
ExecutorEnd(), etc.)

-Neil





pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: adminpack and pg_catalog
Next
From: HS
Date:
Subject: Re: hacking postgres hashjoin algorithm