On Fri, May 9, 2008 at 1:18 AM, Antoine Baudoux <[EMAIL PROTECTED]> 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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
