On Wed, Nov 9, 2011 at 12:56 AM, Josh Berkus <josh@agliodbs.com> wrote:
I'd really like us to release an alpha version based on the finished CF2. There have been a number of major features added to PostgreSQL prior to this CF -- including Haas's performance improvements and range types -- which we really want at least some users to test early.
People trying range types are likely to try indexes on them. GiST on range types implementation in head have some limitations:
1) Full index scan for "column <@ const" case.
2) Absence of selectivity estimation functions for &&, <@, @> cause no GiST index usage until turning enable_seqscan to off.
IMHO, it would be nice to release alpha version with range types without these limitations. I'm going to finish my patch for GiST on range types in couple of days. Concerning selectivity estimation, possible solution is to create some constant estimations with lower selectivity, which make planner use corresponding index by default (like we've for geometric datatypes).