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)
Список
Дерево обсуждения
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 Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: 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 Tom Lane <tgl@sss.pgh.pa.us>
Re: 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 Tom Lane <tgl@sss.pgh.pa.us>
Re: 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 Tom Lane <tgl@sss.pgh.pa.us>
Re: index scan with index cond on first column doesn't recognize sort order of second column Tom Lane <tgl@sss.pgh.pa.us>
Re: index scan with index cond on first column doesn't Stephan Szabo <sszabo@megazone23.bigpanda.com>
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
Дата:
