Re: BETWEEN optimizer problems with single-value range

Merlin Moncure <mmoncure(at)gmail(dot)com> schrieb:

> On 3/15/06, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> > Attached is a simplified example of a performance problem we have seen,
> > with a workaround and a suggestion for enhancement (hence both the
> > performance and hackers lists).
>
>
> Hi Kevin. In postgres 8.2 you will be able to use the row-wise

8.2? AFAIK, Feature freeze in juni/juli this year...
Release august/september.

> comparison for your query which should guarantee good worst case
> performance without having to maintain two separate query forms. it

Perhaps, a bitmap index scan (since 8.1) are useful for such querys.
Thats why i asked which version.

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°