On Fri, May 9, 2008 at 1:18 AM, Antoine Baudoux <ab(at)taktik(dot)be> wrote:
> Ok, I've tried everything, and the planner keeps choosing index scans when
> it shouldnt.
>
> Is there a way to disable index scans?
You can use "set enable_indexscan off;" as the first command I've had
one or two reporting queries in the past that it was a necessity to do
that before running certain queries on very large datasets where a seq
scan would kill performance.