On 05/05/13 15:06, Tom Lane wrote:
Steve Rogerson <steve.pg@xxxxxxxxxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
