Re: My indexes aren't being used (according to EXPLAIN)

The ANALYSE did the trick... Thanks! Will also read through the
archives...

-Erik

On lunes, dici 1, 2003, at 15:04 Europe/Madrid, Andrew Sullivan wrote:

> On Mon, Dec 01, 2003 at 02:40:30PM +0100, Erik Norvelle wrote:
>>
>> it=> explain select * from indethom where clavis < 25;
>
> What's the percentage of the table where clavis < 25? Have you
> ANALYSEd recently? What does the pg_stats view tell you about this
> table?
>
>> Feel free to point me to any FAQ or previous message that already
>> answers this question. Thanks in advance!
>
> This is a pretty common sort of problem. See the archives of this
> list for several fairly recent discussions of these sorts of
> problems.
>
> A
>
> --
> ----
> Andrew Sullivan 204-4141 Yonge Street
> Afilias Canada Toronto, Ontario Canada
> <andrew(at)libertyrms(dot)info> M2P 2A8
> +1 416 646 3304 x110
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>