Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Bad planner decision - bitmap scan instead of index
- From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
- To: Frank Schoep <frank(at)ffnn(dot)nl>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Bad planner decision - bitmap scan instead of index
- Date: Fri, 17 Aug 2007 09:28:39 +0200
On Thu, Aug 16, 2007 at 06:14:02PM +0200, Frank Schoep wrote: > The (example) query: > SELECT * FROM movies WHERE letter = 'T' ORDER BY name ASC LIMIT 100 > OFFSET 1900; try to change the query to: SELECT * FROM movies WHERE letter = 'T' ORDER BY letter ASC, name ASC LIMIT 100 OFFSET 1900; depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV)
- Follow-Ups:
- Re: Bad planner decision - bitmap scan instead of index
- From: Frank Schoep
- Re: Bad planner decision - bitmap scan instead of index
- References:
- Bad planner decision - bitmap scan instead of index
- From: Frank Schoep
- Bad planner decision - bitmap scan instead of index
- Prev by Date: Performance Solaris vs Linux
- Next by Date: Re: Bad planner decision - bitmap scan instead of index
- Previous by thread: Re: Bad planner decision - bitmap scan instead of index
- Next by thread: Re: Bad planner decision - bitmap scan instead of index
- Indexes: