Thread: Fwd: Statistics and selectivity estimation for ranges

Fwd: Statistics and selectivity estimation for ranges

From
Matthias
Date:
Having statistics on ranges was really missing! The planner was doing
some really, really bad choices on bigger tables regarding seq/random
scans, nested loop/other joins etc.

Is there any chance this makes it into 9.2 final? It would really
round-off the introduction of range types and maybe avoid problems
like "the new range types are slow" (just due to the bad row
estimates).

Thanks for implementing this feature,
-Matthias


Re: Fwd: Statistics and selectivity estimation for ranges

From
Josh Berkus
Date:
> Is there any chance this makes it into 9.2 final? It would really
> round-off the introduction of range types and maybe avoid problems
> like "the new range types are slow" (just due to the bad row
> estimates).

Nope, that's strictly a 9.3 feature.  9.2 is in beta2.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com