Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.1 -- very slow query time because of "BETWEEN" (dbmail) - Mailing list pgsql-novice

From Tom Lane
Subject Re: 8.1 -- very slow query time because of "BETWEEN" (dbmail)
Date
Msg-id 10623.1182478262@sss.pgh.pa.us
Whole thread Raw
In response to 8.1 -- very slow query time because of "BETWEEN" (dbmail)  (Brian Neu <proclivity76@yahoo.com>)
Responses Re: 8.1 -- very slow query time because of "BETWEEN" (dbmail)  (Brian Neu <proclivity76@yahoo.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Brian Neu
Date:
Subject: 8.1 -- very slow query time because of "BETWEEN" (dbmail)
Next
From: Brian Neu
Date:
Subject: Re: 8.1 -- very slow query time because of "BETWEEN" (dbmail)