Re: multiple joins + Order by + LIMIT query performance issue
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
: Shaun Thomas <
sthomas@xxxxxxxxxxxxxxxxxx
>
Subject
: Re: multiple joins + Order by + LIMIT query performance issue
From
: Antoine Baudoux <
ab@xxxxxxxxx
>
Date
: Fri, 9 May 2008 09:18:39 +0200
Cc
: "
pgsql-performance@xxxxxxxxxxxxxx
" <
pgsql-performance@xxxxxxxxxxxxxx
>
In-reply-to
: <
1210098273.14833.55.camel@berners-lee
>
References
: <
938EC908-FB9A-4BFA-950A-053BE3C87085@xxxxxxxxx
> <
1210092220.14833.33.camel@berners-lee
> <
ED75A52A-2CBC-4EA3-AE1A-E344B08A9682@xxxxxxxxx
> <
1210098273.14833.55.camel@berners-lee
>
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
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
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
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
