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

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: LIMIT causes planner to do Index Scan using a less optimal index
Дата
Msg-id n2g603c8f071004061722ja3a5d32x2e9738eb402b19d0@mail.gmail.com
обсуждение исходный текст
Список pgsql-performance
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

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

Предыдущее
От: Samuel Gendler
Дата:
Сообщение: indexes in partitioned tables - again
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: query slow; strace output worrisome