Re: Bug in query planer ?

Clifford Wolf <clifford(dot)wolf(at)linbit(dot)com> 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