Re: 8.1 -- very slow query time because of "BETWEEN" (dbmail)

Brian Neu <proclivity76@yahoo.com> writes:
> The strange part is that if you change the "BETWEEN" to just an "= 253775"  . . . the query takes around 70ms.

Please show EXPLAIN ANALYZE output for both cases.  I suppose it's
changing plans but it's not clear why.

> Is my answer to just upgrade to 8.2 ?  Is this a known problem in 8.1 ?

8.1.which?

            regards, tom lane