Re: [9.2devel] why it doesn't do index scan only?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [9.2devel] why it doesn't do index scan only?
Дата
Msg-id CAFj8pRD993VN2__=sUM1_sKB6S28BWej5Ay4UZ1QKJozajpAhA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [9.2devel] why it doesn't do index scan only?  (Thom Brown <thom@linux.com>)
Ответы Re: [9.2devel] why it doesn't do index scan only?
Список pgsql-general
>> I did it. It is strange, so your times are significantly slower than I
>> have. Have you enabled asserts?
>
> The table contains 15 million rows with column values randomly
> selected from the 1-350 range, with 60% within the 1-50 range, and
> asserts are enabled.
>

Now I repeated tests on litlle bit wide table with 9 milion rows, but
without success.

Try to disable asserts. I am not sure, but maybe there significantlly
change a speed.

Pavel

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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: [9.2devel] why it doesn't do index scan only?
Следующее
От: Thom Brown
Дата:
Сообщение: Re: [9.2devel] why it doesn't do index scan only?