Re: Optimizer bug?? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Optimizer bug??
Date
Msg-id 20040524182331.GG3140@dcc.uchile.cl
Whole thread Raw
In response to Re: Optimizer bug??  ("Ismail Kizir" <ikizir@tumgazeteler.com>)
List pgsql-hackers
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.



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Big problem
Next
From: "Magnus Hagander"
Date:
Subject: Re: New horology failure