Postgres Pro
Downloads
Home   >   mailing lists

Re: bitmap scan and explain analyze - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: bitmap scan and explain analyze
Date
Msg-id 20050505.120936.58461787.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: bitmap scan and explain analyze  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: bitmap scan and explain analyze  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
> > Why actual rows=0?
> 
> I couldn't think of any reasonably cheap way to count the actual rows
> (especially in the presence of lossy bitmaps), so I just punted.

I see.

BTW is it possible to let BitmapHeapScan fetch tuples by TID order? It
would make heap acccess in sequential manner and would boost disk
access performance.
--
Tatsuo Ishii

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [pgsql-advocacy] Increased company involvement
Next
From: "Marc G. Fournier"
Date:
Subject: Re: [pgsql-advocacy] Increased company involvement