Postgres Pro
Downloads
Home   >   mailing lists

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

From Antoine Baudoux
Subject Re: multiple joins + Order by + LIMIT query performance issue
Date
Msg-id 17BEF74A-6B90-4BAD-8612-3548B616AFC7@taktik.be
Whole thread Raw
In response to Re: multiple joins + Order by + LIMIT query performance issue  (Shaun Thomas <sthomas@leapfrogonline.com>)
Responses Re: multiple joins + Order by + LIMIT query performance issue  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
Tree view 
Ok, I've tried everything, and the planner keeps choosing index scans
when it shouldnt.

Is there a way to disable index scans?


Antoine

pgsql-performance by date:

Previous
From: Rauan Maemirov
Date:
Subject: Re: Creating indexes
Next
From: "Scott Marlowe"
Date:
Subject: Re: multiple joins + Order by + LIMIT query performance issue