Postgres Pro
Downloads
Home   >   mailing lists

Re: another "EXPLAIN -- NO INDEX?" question - Mailing list pgsql-general

From Neil Conway
Subject Re: another "EXPLAIN -- NO INDEX?" question
Date
Msg-id 1013357854.323.519.camel@jiro
Whole thread Raw
In response to another "EXPLAIN -- NO INDEX?" question  (will trillich <will@serensoft.com>)
List pgsql-general
Tree view 
On Sun, 2002-02-10 at 09:54, will trillich wrote:
> okay, i've seen tom's discourse on the explain feature at
> http://www.ca.postgresql.org/users-lounge/docs/7.0/user/c4884.htm

Keep in mind you're using old docs...

> but i can't grok why this index is ignored:

Have you VACUUM ANALYZE'd or ANALYZE'd the tables in question?

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: what's the meaning of the word "Tioga" in source
Next
From: Tom Lane
Date:
Subject: Re: what's the meaning of the word "Tioga" in source