Re: multiple joins + Order by + LIMIT query performance issue - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: multiple joins + Order by + LIMIT query performance issue
Date
Msg-id dcc563d10805090053l2075c4acra2925264040e808b@mail.gmail.com
Whole thread Raw
In response to Re: multiple joins + Order by + LIMIT query performance issue  (Antoine Baudoux <ab@taktik.be>)
List pgsql-performance
On Fri, May 9, 2008 at 1:18 AM, Antoine Baudoux <ab@taktik.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.

pgsql-performance by date:

Previous
From: Antoine Baudoux
Date:
Subject: Re: multiple joins + Order by + LIMIT query performance issue
Next
From: Frank Dekervel
Date:
Subject: "append" takes a lot of time in a query