PRIMARY KEY and indexes - Mailing list pgsql-general

From Craig Bryden
Subject PRIMARY KEY and indexes
Date
Msg-id 000901c547e9$3873ea80$0200a8c0@amd2800
Whole thread Raw
Responses Re: PRIMARY KEY and indexes  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Hi

I come from a MS-SQL background and I'm trying to get some clarity on
indexes in Postgres. If anyone can help with the following questions it
would be much appreciated:

1. When creating a primary key contraint on a table, is an equivalent index
automatically created for you, or would I have to create an index manually?
2. How do I create a clustered index in postgres?

Thanks
Craig


pgsql-general by date:

Previous
From: "Uwe C. Schroeder"
Date:
Subject: Re: UltraSPARC versus AMD
Next
From: William Yu
Date:
Subject: Re: UltraSPARC versus AMD