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

From Greg Stark
Subject Re: Optimizer bug??
Date
Msg-id 87ekp9pual.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Optimizer bug??  ("Ismail Kizir" <ikizir@tumgazeteler.com>)
List pgsql-hackers
"Ismail Kizir" <ikizir@tumgazeteler.com> writes:

> Thanks Hans,
> 
> The optimizer does an indexed scan up to 20 days, and then, it decides to
> make a sequential scan.

What are the results of "explain analyze <query>" for the various queries?

-- 
greg



pgsql-hackers by date:

Previous
From: "Ismail Kizir"
Date:
Subject: Re: Optimizer bug??
Next
From: Alvaro Herrera
Date:
Subject: Re: Big problem