• Tom Lane's avatar
    Support min/max index optimizations on boolean columns. · cbba55d6
    Tom Lane authored
    Since bool_and() is equivalent to min(), and bool_or() to max(), we might
    as well let them be index-optimized in the same way.  The practical value
    of this is debatable at best, but it seems nearly cost-free to enable it.
    Code-wise, we need only adjust the entries in pg_aggregate.  There is a
    measurable planning speed penalty for a query involving one of these
    aggregates, but it is only a few percent in simple cases, so that seems
    acceptable.
    
    Marti Raudsepp, reviewed by Abhijit Menon-Sen
    cbba55d6
pg_aggregate.h 10.3 KB