Re: [HACKERS] has anybody else used r-tree indexes in 6.5?

> The right fix would be to put in an appropriate selectivity estimator,
> but we can't do that as a 6.5.* patch because changing pg_operator
> requires an initdb. It will have to wait for 6.6. (One of my to-do
> items for 6.6 was to rewrite the selectivity estimators anyway, so I'll
> see what I can do.) In the meantime, I think the only possible patch is
> to disable the error check in btreesel and have it return a default
> selectivity estimate instead of complaining. Drat.
>
> Apparently, none of the regression tests exercise rtree indexes at all,
> else we'd have known there was a problem. Adding an rtree regression test
> seems to be strongly indicated as well...

Sounds like a good fix. Bypass the system tables, since we can't change
them, and hard-wire a selectivity.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026