Re: Why is the query not using the index for sorting?

Поиск
Список
Период
Сортировка
Искать
От
Matthew Wakeling
Тема
Re: Why is the query not using the index for sorting?
Дата
Msg-id
alpine.DEB.2.00.0911231058560.684@aragorn.flymine.org
Ответ на
Why is the query not using the index for sorting? (Jonathan Blitz)
Список
Дерево обсуждения
Why is the query not using the index for sorting? Jonathan Blitz <jblitz@013.net>
Re: Why is the query not using the index for sorting? Craig Ringer <craig@postnewspapers.com.au>
Re: Why is the query not using the index for sorting? Jonathan Blitz <jblitz@013.net>
Re: Why is the query not using the index for sorting? Matthew Wakeling <matthew@flymine.org>
Re: Why is the query not using the index for sorting? Jonathan Blitz <jblitz@013.net>
Re: Why is the query not using the index for sorting? Thom Brown <thombrown@gmail.com> 
On Sun, 22 Nov 2009, Jonathan Blitz wrote:
> I have a table with a number of columns.
>  
> I perform
>  
> Select *
> from table
> order by a,b
>  
> There is an index on a,b which is clustered (as well as indexes on a and b alone).
> I have issued the cluster and anyalze commands.

Did you analyse *after* creating the index and clustering, or before?

Matthew

-- 
 [About NP-completeness] These are the problems that make efficient use of
 the Fairy Godmother.                    -- Computer Science Lecturer
В списке pgsql-performance по дате отправления
Предыдущее
От: Sergey Aleynikov
Дата:
Следующее
От: Matthew Wakeling
Дата:
FAQ