bitmap scans, btree scans, and tid order

From: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: bitmap scans, btree scans, and tid order
Date: 2005-05-16 04:24:59
Message-ID: 1116217499.27958.7.camel@noodles
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

About this time last year I was holding forth on the value of visiting
the heap in TID order, even when index scan tuples are randomly ordered.
Today I decided to start working on the problem stated in this TODO
item:

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.

I see that Tom has already done the infrastructure work by adding
getmulti, but getmulti isn't used by nodeIndexscan.c, only
nodeBitmapIndexscan.c. Will btree index scans be executed by creating
in-memory bitmaps in 8.1, or will some scans still be executed the usual
way? If the former, I'd be wasting time, but in the latter case it
would be worth it.

-jwb

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2005-05-16 04:45:30 Re: [Fwd: Re: SQL99 Hierarchical queries]
Previous Message Alvaro Herrera 2005-05-16 04:04:31 Re: [ADMIN] Permissions not removed when group dropped