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])