Douglas Thomson <dougt(at)mugc(dot)cc(dot)monash(dot)edu(dot)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