Re: TODO list comments - Mailing list pgsql-hackers

From Kris Jurka
Subject Re: TODO list comments
Date
Msg-id Pine.BSO.4.62.0508242151580.29227@leary.csoft.net
Whole thread Raw
In response to TODO list comments  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: TODO list comments
List pgsql-hackers

On Wed, 24 Aug 2005, Tom Lane wrote:

>> * Fetch heap pages matching index entries in sequential order
>>
>>   Rather than randomly accessing heap pages based on index entries, mark
>>   heap pages needing access in a bitmap and do the lookups in sequential
>>   order. Another method would be to sort heap ctids matching the index
>>   before accessing the heap rows.
>
> This is done (see bitmap index scans).
>

Will the optimizer ever choose this plan when dealing with only one index?

Kris Jurka


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] Proposed patch to getaddrinfo.c to support
Next
From: Tom Lane
Date:
Subject: Re: TODO list comments