Re: Optimizer bug??

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Optimizer bug??
Date: 2004-05-24 18:13:54
Message-ID: 87ekp9pual.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Ismail Kizir" <ikizir(at)tumgazeteler(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2004-05-24 18:22:41 Re: Big problem
Previous Message Ismail Kizir 2004-05-24 17:27:01 Re: Optimizer bug??