Tom Lane wrote:
> "Jens-Wolfhard Schicke" <j.schicke@asco.de> writes:
>
>> I an explain analyze I saw recently, a BitmapOr node of 5 Bitmap Index Scan
>> looked like this:
>> BitmapOr (cost=43.57..43.57 rows=1833 width=0) (actual time=0.146..0.146
>> rows=0 loops=1)
>>
>
>
Can we do better than just saying 0? something indicating not
calculated, or the fact we can't calculate it?
> BitmapOr and BitmapAnd don't attempt to count their result rows --- doing
> so would involve an extra scan over the bitmap, and what would you do
> for lossy pages?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>