> > Another thing that this brings up is "hints" to a query. Over the 
> > years, I have run into situation where the planner wasn't 
> great.  It 
> > would be nice to try forcing different strategies on the 
> planner and 
> > see if performance caan be improved.
> >
> you can do this by setting enable_"access_method" type parameters.

No, not generally. Usual problems include join order and wrong index,
not only wrong access method.


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to