Re: Bad planner decision - bitmap scan instead of index
От
hubert depesz lubaczewski
Тема
Re: Bad planner decision - bitmap scan instead of index
Дата
Msg-id
20070817072839.GA6598@depesz.com
Ответ на
Bad planner decision - bitmap scan instead of index (Frank Schoep)
Список
Дерево обсуждения
Bad planner decision - bitmap scan instead of index Frank Schoep <frank@ffnn.nl>
Re: Bad planner decision - bitmap scan instead of index hubert depesz lubaczewski <depesz@depesz.com>
Re: Bad planner decision - bitmap scan instead of index Frank Schoep <frank@ffnn.nl>
Re: Bad planner decision - bitmap scan instead of index Michael Stone <mstone+postgres@mathom.us>
Re: Bad planner decision - bitmap scan instead of index Frank Schoep <frank@ffnn.nl>
Re: Bad planner decision - bitmap scan instead of index Tom Lane <tgl@sss.pgh.pa.us>
Re: Bad planner decision - bitmap scan instead of index Frank Schoep <frank@ffnn.nl>
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)
В списке pgsql-performance по дате отправления
