Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Index of a table is not used (in any case)

From: Doug McNaught <doug(at)wireboard(dot)com>
To: Reiner Dassing <dassing(at)wettzell(dot)ifag(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Index of a table is not used (in any case)
Date: 2001-10-23 04:00:24
Message-ID: m3d73fhup3.fsf@belphigor.mcnaught.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-sql
Reiner Dassing <dassing(at)wettzell(dot)ifag(dot)de> writes:

> Hello PostgreSQl Users!
> 
> PostSQL V 7.1.1:
> 
> I have defined a table and the necessary indices.
> But the index is not used in every SELECT. (Therefore, the selects are
> *very* slow, due to seq scan on
> 20 million entries, which is a test setup up to now)

Perennial first question: did you VACUUM ANALYZE?

-Doug
-- 
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

In response to

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2001-10-23 04:08:14
Subject: Re: [HACKERS] Index of a table is not used (in any case)
Previous:From: Lamar OwenDate: 2001-10-23 03:56:24
Subject: Re: [GENERAL] To Postgres Devs : Wouldn't changing the selectlimit

pgsql-sql by date

Next:From: Christopher Kings-LynneDate: 2001-10-23 04:08:14
Subject: Re: [HACKERS] Index of a table is not used (in any case)
Previous:From: Stephan SzaboDate: 2001-10-23 02:17:08
Subject: Re: cast

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group