Re: possible optimizations - pushing filter before aggregation - Mailing list pgsql-hackers

From Tom Lane
Subject Re: possible optimizations - pushing filter before aggregation
Date
Msg-id 19917.1479585023@sss.pgh.pa.us
Whole thread Raw
In response to Re: possible optimizations - pushing filter before aggregation  (Douglas Doole <dougdoole@gmail.com>)
List pgsql-hackers
Douglas Doole <dougdoole@gmail.com> writes:
> For min, you should be able to pre-filter =, < , and <=. In all cases the
> pre-filter would be <=. For max it would be =, > , >= becoming >=.

Doesn't really seem worth the trouble to me, given that those are pretty
unselective filter conditions.  If you could push down an = then it might
be worth doing ...
        regards, tom lane



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: macaddr 64 bit (EUI-64) datatype support
Next
From: Tom Lane
Date:
Subject: Re: macaddr 64 bit (EUI-64) datatype support