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 ?
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Brian Neu||Date: 2007-06-22 03:05:10|
|Subject: Re: 8.1 -- very slow query time because of "BETWEEN" (dbmail) |
|Previous:||From: Brian Neu||Date: 2007-06-22 01:30:03|
|Subject: 8.1 -- very slow query time because of "BETWEEN" (dbmail)|