Home > mailing lists

INDEXes and UNIQUES and PRIMARY KEYS - Mailing list pgsql-general

From	Chris Bitmead
Subject	INDEXes and UNIQUES and PRIMARY KEYS
Date	April 26, 1999 23:53:34
Msg-id	37250ADE.F1705137@bigfoot.com Whole thread Raw
In response to	9k limit? ("Justin Long" <justinlong@strategicnetwork.org>)
List	pgsql-general

Tree view

If I have a UNIQUE or PRIMARY KEY clause on my class, does that create a
btree or hash index?

I guess if I have a UNIQUE constraint or PRIMARY KEY at class creation,
I don't have to create an index explicitely via CREATE INDEX ?

pgsql-general by date:

From: Jim Jennis
Date: 26 April 1999, 20:26:26
Subject: Re: [GENERAL] advice on buying sun hardware to run postgres

From: Chris Bitmead
Date: 27 April 1999, 00:00:27
Subject: UNIQUE performance?

INDEXes and UNIQUES and PRIMARY KEYS - Mailing list pgsql-general

Previous

Next