Postgres Pro
Downloads
Home   >   mailing lists

Re: Planner problems in 8.2.4 and 8.2.5 (was: Possible planner bug/regression introduced in 8.2.5) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Planner problems in 8.2.4 and 8.2.5 (was: Possible planner bug/regression introduced in 8.2.5)
Date
Msg-id 886.1194384587@sss.pgh.pa.us
Whole thread Raw
In response to Re: Planner problems in 8.2.4 and 8.2.5 (was: Possible planner bug/regression introduced in 8.2.5)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Planner problems in 8.2.4 and 8.2.5 (was: Possible planner bug/regression introduced in 8.2.5)
List pgsql-bugs
Tree view 
I wrote:
> This might be a bug in the LIKE estimator (if so, it's in 8.2.3 as
> well).  I don't have time to look closer right now, but can you show us
> the pg_stats row for orders_smaller.order_number?

Oh, never mind that ... on inspection, the NOT LIKE selectivity
estimator is obviously broken: patternsel() doesn't realize it needs
to negate the results of the operator when applying same to histogram
entries.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Planner problems in 8.2.4 and 8.2.5 (was: Possible planner bug/regression introduced in 8.2.5)
Next
From: Steve Langasek
Date:
Subject: Re: Test suite fails on alpha architecture