Re: Index trouble with 8.3b4 - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: Index trouble with 8.3b4
Date
Msg-id 87tzleq5f7.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Index trouble with 8.3b4  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Index trouble with 8.3b4  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Index trouble with 8.3b4
Next
From: Tom Lane
Date:
Subject: Re: Index trouble with 8.3b4