Re: index vs. seq scan choice?

George Pavlov wrote:
>> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>> "George Pavlov" <gpavlov@mynewplace.com> writes:

> to 977ms! If I go the other way and SET STATISTICS 1 (or 0) I can bring
> down the list to one entry (setting to 0 seems equivalent and still
> keeps the one most common entry!?) and I will get the Index scan for all
> states except for that one most common state. But, of course, I don't
> want to undermine the whole stats mechanism, I just want the system to
> use the index that is so helpful and brings runtimes down by a factor of
> 4-8! What am I missing here?

In those rare cases wouldn't it make more sense to just set
enable_seqscan to off; run query; set enable_seqscan to on;

??

Joshua D. Drake


>
> George
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>


--

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/