Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group