Re: index scan with index cond on first column doesn't

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: index scan with index cond on first column doesn't
Дата
Msg-id 20030213113156.T47380-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на index scan with index cond on first column doesn't recognize sort order of second column  (Greg Stark <gsstark@mit.edu>)
Ответы Re: index scan with index cond on first column doesn't recognize sort order of second column
Список pgsql-general
On 13 Feb 2003, Greg Stark wrote:

> Here's a corner case where the optimizer is doing a redundant sort. I'm not
> sure if I'm doing something wrong or if it's just something the optimizer
> doesn't notice.

I'm guessing that it doesn't realize that in this case the sort is
redundant since I think it's only necessarily redundant for = singlevalue
with no ors.



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

Предыдущее
От: Emmanuel Charpentier
Дата:
Сообщение: Aggregates with non-commutative transition functions
Следующее
От: Egyud Csaba
Дата:
Сообщение: Fw: set returning functions in v7.3