Re: Why does a simple query not use an obvious index?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Why does a simple query not use an obvious index?
Дата
Msg-id 87llfxk5v6.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Why does a simple query not use an obvious index?  (Mr Pink <mr_pink_is_the_only_pro@yahoo.com>)
Ответы Re: Why does a simple query not use an obvious index?  (Mr Pink <mr_pink_is_the_only_pro@yahoo.com>)
Список pgsql-performance
Mr Pink <mr_pink_is_the_only_pro@yahoo.com> writes:

> AFAIK postgres doesn't peek at values used in a query when optimizing

Of course it does.

However sometimes things don't work perfectly.
To get good answers rather than just guesses we'll need two things:

. What version of postgres are you using.
. The output of EXPLAIN ANALYZE select ...

--
greg

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Equivalent praxis to CLUSTERED INDEX?
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Why does a simple query not use an obvious index?