Re: [INTERFACES] Slow join query optimisation? - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] Slow join query optimisation?
Date
Msg-id 27908.944148103@sss.pgh.pa.us
Whole thread Raw
In response to Re: [INTERFACES] Slow join query optimisation?  (Douglas Thomson <dougt@mugc.cc.monash.edu.au>)
Responses Re: [INTERFACES] Slow join query optimisation?  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-interfaces
Douglas Thomson <dougt@mugc.cc.monash.edu.au> writes:
> Is there any way to turn off the optimisation? Or perhaps some way to
> work out the optimal strategy once, and then provide this information
> directly?

Not at the moment.  There's been some talk of caching query plans,
which would get the job done, but none of the current developers are
working on that now.  It'll probably happen someday...
        regards, tom lane

************




pgsql-interfaces by date:

Previous
From: Douglas Thomson
Date:
Subject: Re: [INTERFACES] Slow join query optimisation?
Next
From: "UEBAYASHI 'UMA' Masao"
Date:
Subject: [INTERFACES] ecpg: why use PREPARE?