Re: Composite fields and the query planner

On 05/05/13 15:06, Tom Lane wrote:
> Steve Rogerson <steve.pg@yewtc.demon.co.uk> writes:
>> I'm seeing a problem with the query planner not doing what's expected, and I
>> think it is because we are using composite fields. Here is a stripped down
>> example.
>
> I tested this example in HEAD and 9.0.x and didn't see any particular
> problem with rowcount estimates for the get_part1() expression.  You
> do have to have the i1 index in place when the table is analyzed, else
> ANALYZE won't collect any stats about the expression.
>
>             regards, tom lane

I should have said I am using 9.0.7 - also I have "ANALYZEd" all the relevant
tables. Having said that I am having problems re-creating a rich enough example.

Steve