Re: Index doesn't appear to be working.

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Index doesn't appear to be working.
Date: 2002-03-03 18:41:21
Message-ID: 5.1.0.14.0.20020303133718.0338c150@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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..."

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message John Oakes 2002-03-03 19:27:12 - Finding records in sequence
Previous Message Bruce Momjian 2002-03-03 18:36:10 Re: Index doesn't appear to be working.