Re: Optimizer misconfigured ? - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Optimizer misconfigured ?
Date
Msg-id 434F607F.8080100@archonet.com
Whole thread Raw
In response to Re: Optimizer misconfigured ?  (Nörder-Tuitje, Marcus <noerder-tuitje@technology.de>)
List pgsql-performance
Nörder-Tuitje wrote:
> Hi,
>
> meanwhile I have received the hint to make postgres use the index via
>
>
> SET ENABLE_SEQSCAN=FALSE;
>
> which fits perfectly. The execution plan now indicates full use of
> index.

What execution plan? I still only see one message on the list.

> Nevertheless this is merely a workaround. Maybe the io-costs are
> configured to cheap.

Possibly - the explain analyse will show you.
--
   Richard Huxton
   Archonet Ltd


pgsql-performance by date:

Previous
From: Nörder-Tuitje, Marcus
Date:
Subject: Re: Optimizer misconfigured ?
Next
From:
Date:
Subject: Best way to get all different values in a column