Обсуждение: Re: LIMIT causes planner to do Index Scan using a less optimal index

Поиск
Список
Период
Сортировка

Re: LIMIT causes planner to do Index Scan using a less optimal index

От
Robert Haas
Дата:
On Tue, Apr 6, 2010 at 6:30 PM, Joel Jacobson <joel@gluefinance.com> wrote:
Actually, swapping the order of the conditions did in fact make some difference, strange.

I ran the query a couple of times for each variation to see if the difference in speed was just a coincidence or a pattern. Looks like the speed really is different.

Wow.  That's very surprising to me...

...Robert