Received: from belphigor.mcnaught.org ([216.151.155.121]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9N40eP15096; Tue, 23 Oct 2001 00:00:40 -0400 (EDT) (envelope-from doug@wireboard.com) Received: (from doug@localhost) by belphigor.mcnaught.org (8.11.6/8.9.3) id f9N40OV12513; Tue, 23 Oct 2001 00:00:24 -0400 X-Authentication-Warning: belphigor.mcnaught.org: doug set sender to doug@wireboard.com using -f To: Reiner Dassing Cc: pgsql-sql@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Index of a table is not used (in any case) References: <3BD3BFE0.55FC3EC0@wettzell.ifag.de> From: Doug McNaught Date: 23 Oct 2001 00:00:24 -0400 In-Reply-To: Reiner Dassing's message of "Mon, 22 Oct 2001 08:42:40 +0200" Message-ID: Lines: 17 User-Agent: Gnus/5.0806 (Gnus v5.8.6) XEmacs/21.1 (20 Minutes to Nikko) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200110/321 X-Sequence-Number: 5274 Reiner Dassing 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