Re: Composite fields and the query planner - Mailing list pgsql-general

From Steve Rogerson
Subject Re: Composite fields and the query planner
Date
Msg-id 5188C00C.3090704@yewtc.demon.co.uk
Whole thread Raw
In response to Re: Composite fields and the query planner  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: "Unlogged indexes"
Next
From: Johann Spies
Date:
Subject: Insert not finishing