Re: [GENERAL] Forcing Postgres to Execute a Specific Plan

2008-06-02 Thread John Cieslewicz
tems, I'm still getting familiar with postgres. Could such a piece of code be placed in the optimizer just before it returns an optimized plan or can a plan be modified after it is returned by the optimizer? John Cieslewicz. On Jun 2, 2008, at 5:24 PM, Scott Marlowe wrote: Not rea

[GENERAL] Forcing Postgres to Execute a Specific Plan

2008-06-02 Thread John Cieslewicz
I'm doing some performance experiments with postgres (8.3.1) and would like to force postgres to execute a particular query plan. Is there a straightforward way to specify a query plan to postgres either interactively or programatically? Thanks. John Cieslewicz. -- Sent via pgsql-ge