Re: About when we should setup index?

On Tue, Mar 07, 2006 at 09:54:11AM -0500, Emi Lu wrote:
> Thank you very much Michael. Your inputs are very helpful for me. Just
> have one small question, the example you gave is based on  postgresql
> 8.1, does it apply to PostgreSQL 8.0.1 as well (i686-pc-linux-gnu,
> compiled by GCC gcc 3.3.2)?

What example?  I only mentioned 8.1 in the context of queries against
low-cardinality columns (columns with only a few distinct values) but
I didn't show an example of that.

> >Yes.  When you issue the CREATE TABLE statement you should see a
> >notice like the following:
> >
> >CREATE TABLE / PRIMARY KEY will create implicit index "test_pkey" for
> >table "test"

Is this the example you meant?  Earlier versions of PostgreSQL work
the same way.

--
Michael Fuhr