Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> So, while I have been known to suggest "set enable_seqscan=off" and
>> friends when there seemed no other short-term answer, I don't want to
>> enshrine it as a standard recommendation. It's just a way of plugging
>> holes in the dike until more planner work gets done.
> They can certainly turn of off before a query and on after the query,
> right?
Sure, that's how I'd suggest using it at the moment.
> Seems people have been asking for fine-tuned optimizer control.
I know, but I think that's the wrong direction to go in, for the reasons
I tried to explain. The more specific the command you give to force
a particular query plan, the more likely that command is to go wrong
as the situation changes.
regards, tom lane