Re: [HACKERS] bitmap scan and explain analyze

> > BTW is it possible to let BitmapHeapScan fetch tuples by TID order? > > It already does ... Oh great. It seems tbm_begin_iterate() does the trick... -- Tatsuo Ishii ---(end of broadcast)--- TIP 7: don't forget to increase your free space map se

Re: [HACKERS] bitmap scan and explain analyze

Tatsuo Ishii <[EMAIL PROTECTED]> writes: > BTW is it possible to let BitmapHeapScan fetch tuples by TID order? It already does ... regards, tom lane ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choo

Re: [HACKERS] bitmap scan and explain analyze

> > 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

Re: [HACKERS] bitmap scan and explain analyze

Tatsuo Ishii <[EMAIL PROTECTED]> writes: > 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. regards, tom lane ---(end of broadcast)