Re: Question about Bitmap Heap Scan/BitmapAnd

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Guillaume Smet" <guillaume.smet@xxxxxxxxx> writes:
> What surprises me is that "parking" is in the filter and not in the
> Recheck Cond whereas it's part of the second Bitmap Index Scan of the
> Bitmap And node.

That's probably because of this:

    /*
     * When dealing with special or lossy operators, we will at this point
     * have duplicate clauses in qpqual and bitmapqualorig.  We may as well
     * drop 'em from bitmapqualorig, since there's no point in making the
     * tests twice.
     */
    bitmapqualorig = list_difference_ptr(bitmapqualorig, qpqual);

What's not immediately clear is why the condition was in both lists to
start with.  Perhaps idx_lieu_parking is a partial index with this as
its WHERE condition?

			regards, tom lane


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux