UNIQUE constraint and indexing - Mailing list pgsql-general

From Arcady Genkin
Subject UNIQUE constraint and indexing
Date
Msg-id r1zpu8cfeqt.fsf@bashful.cdf.toronto.edu
Whole thread Raw
Responses Re: UNIQUE constraint and indexing
Re: UNIQUE constraint and indexing
List pgsql-general
Is the index, created implicitely by "UNIQUE" constraint, the same
kind as created explicitely with "CREATE INDEX"?  In other words,
is the following piece of SQL redundant?

create table foo (
       bar serial primary key,
       baz text not null unique );
create index foo_baz_idx on foo(baz);

Many thanks,
--
Arcady Genkin
i=1; while 1, hilb(i); i=i+1; end

pgsql-general by date:

Previous
From: Dominique Dumortier
Date:
Subject: PostGres is not using indices in select, I would like it to because it is too slow !
Next
From: Bruce Momjian
Date:
Subject: Re: How to make a REALLY FAST db server?