Re: Index trouble with 8.3b4

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: Index trouble with 8.3b4
Дата
Msg-id 87tzleq5f7.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: Index trouble with 8.3b4  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: Index trouble with 8.3b4  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
"Jeff Davis" <pgsql@j-davis.com> writes:

> On Mon, 2008-01-14 at 22:10 -0500, Tom Lane wrote:
>> It's a tossup from here.  Anybody have a strong opinion one way or the
>> other?
>
> To me a heapscan means "read all the tuples" (without implying order)
> and an ordered heap scan is a special case that should be made explicit.
> But this is not a strong opinion.

I had another thought. Perhaps in use_assert_checking mode we should have it
start from a random position every time. Or perhaps just a random position
from amongst the first n pages.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production
Tuning


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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Index trouble with 8.3b4
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Index trouble with 8.3b4