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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian Neu <proclivity76(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: 8.1 -- very slow query time because of "BETWEEN" (dbmail)
Date: 2007-06-22 02:11:02
Message-ID: 10623.1182478262@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Brian Neu <proclivity76(at)yahoo(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Brian Neu 2007-06-22 03:05:10 Re: 8.1 -- very slow query time because of "BETWEEN" (dbmail)
Previous Message Brian Neu 2007-06-22 01:30:03 8.1 -- very slow query time because of "BETWEEN" (dbmail)