Clifford Wolf <[EMAIL PROTECTED]> writes: > However, it would be great to have get_restriction_variable() and > get_attstatsslot() extended so they can pass the most common values > from the statistics cache thru expressions, as described in my earlier > mail.
This would only be helpful if the most-common-values list describes practically all of the column population, which isn't typically the case. In any case I'm not sure why you're resistant to maintaining an index on an expression that you are frequently querying by --- that index could have more direct use than just cueing ANALYZE what to figure statistics on. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend