Skip site navigation (1)
Skip section navigation (2)
Ok, I've tried everything, and the planner keeps choosing index scans when it shouldnt.
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 9 May 2008 09:18:39 +0200
- Message-id: <17BEF74A-6B90-4BAD-8612-3548B616AFC7(at)taktik(dot)be>
Ok, I've tried everything, and the planner keeps choosing index scans when it shouldnt.
Is there a way to disable index scans? Antoine
- Follow-Ups:
- Re: multiple joins + Order by + LIMIT query performance issue
- From: Scott Marlowe
- Re: multiple joins + Order by + LIMIT query performance issue
- References:
- multiple joins + Order by + LIMIT query performance issue
- From: Antoine Baudoux
- Re: multiple joins + Order by + LIMIT query performance issue
- From: Shaun Thomas
- Re: multiple joins + Order by + LIMIT query performance issue
- From: Antoine Baudoux
- Re: multiple joins + Order by + LIMIT query performance issue
- From: Shaun Thomas
- multiple joins + Order by + LIMIT query performance issue
- Prev by Date: Re: Creating indexes
- Next by Date: Re: multiple joins + Order by + LIMIT query performance issue
- Previous by thread: Re: multiple joins + Order by + LIMIT query performance issue
- Next by thread: Re: multiple joins + Order by + LIMIT query performance issue
- Indexes: