Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net [216.55.132.35]) by postgresql.org (Postfix) with ESMTP id EBFB2475E3C for ; Sun, 3 Mar 2002 13:36:14 -0500 (EST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g23IaAl15256; Sun, 3 Mar 2002 13:36:10 -0500 (EST) From: Bruce Momjian Message-Id: <200203031836.g23IaAl15256@candle.pha.pa.us> Subject: Re: Index doesn't appear to be working. In-Reply-To: <5.1.0.14.0.20020303133718.0338c150@pop6.sympatico.ca> To: Frank Bax Date: Sun, 3 Mar 2002 13:36:10 -0500 (EST) Cc: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL96 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200203/29 X-Sequence-Number: 6911 Frank Bax wrote: > At 11:02 AM 03/03/02 -0500, Bruce Momjian wrote: > > Indexes are not automatically used by every query. Indexes are only > > used if the table is larger than a minimum size, and the index > > selects only a small percentage of the rows in the table. > > > Shouldn't it say: > "and the *query* selects only a small percentage..." Yes, I meant "index returns only a small percentage", but query selects is better. Thanks. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026