Re: Slow functional indexes?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Slow functional indexes?
Дата
Msg-id 20906.1161401432@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Slow functional indexes?  (Stuart Bishop <stuart.bishop@canonical.com>)
Ответы Re: Slow functional indexes?  (Stuart Bishop <stuart@stuartbishop.net>)
Список pgsql-performance
Stuart Bishop <stuart.bishop@canonical.com> writes:
> I would like to understand what causes some of my indexes to be slower to
> use than others with PostgreSQL 8.1.

I was about to opine that it was all about different levels of
correlation between the index order and physical table order ... but
your experiments with freshly clustered indexes seem to cast doubt
on that idea.  Are you sure your function is really immutable?  A buggy
function could possibly lead to a "clustered" index not being in
physical order.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Is ODBC that slow?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Is ODBC that slow?