On Mon, May 24, 2004 at 08:27:01PM +0300, Ismail Kizir wrote:

> The optimizer does an indexed scan up to 20 days, and then, it decides to
> make a sequential scan.
> But i am still not sure about the efficiency of this decision.

Huh, so what was the EXPLAIN ANALYZE of the query with BETWEEN?

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Syntax error: function hell() needs an argument.
Please choose what hell you want to involve.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to