Re: multiple joins + Order by + LIMIT query performance issue

From: Antoine Baudoux <ab(at)taktik(dot)be>
To: Shaun Thomas <sthomas(at)leapfrogonline(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: multiple joins + Order by + LIMIT query performance issue
Date: 2008-05-09 07:18:39
Message-ID: 17BEF74A-6B90-4BAD-8612-3548B616AFC7@taktik.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ok, I've tried everything, and the planner keeps choosing index scans
when it shouldnt.

Is there a way to disable index scans?

Antoine

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-05-09 07:53:18 Re: multiple joins + Order by + LIMIT query performance issue
Previous Message Rauan Maemirov 2008-05-09 05:41:22 Re: Creating indexes