Skip site navigation
(1)
Skip section navigation
(2)
Search
Peripheral Links
Text Size:
Normal
/
Large
Donate
Contact
Header And Logo
|
Site Navigation
Home
About
Downloads
Documentation
Community
Developers
Support
Section Navigation
Community
Contributors
Mailing Lists
Subscribe
User lists
pgsql-admin
pgsql-advocacy
pgsql-announce
pgsql-bugs
pgsql-docs
pgsql-cygwin
pgsql-general
pgsql-interfaces
pgsql-jdbc
pgsql-jobs
pgsql-novice
pgsql-odbc
pgsql -performance
pgsql-php
pgsql-ports
pgsql-sql
Developer lists
Regional lists
Project lists
User groups
Inactive lists
IRC
Featured Users
International Sites
Propaganda
Resources
Weekly News
Community login
Profile
Lost password
Search for
Advanced Search
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
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
Indexes:
Main
Thread
Home
|
Main Index
|
Thread Index
Privacy Policy
| PostgreSQL Archives hosted by
Command Prompt, Inc.
| Designed by
tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group