Re: PRIMARY KEY and indexes - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: PRIMARY KEY and indexes
Date
Msg-id 20050423152704.GB25846@dcc.uchile.cl
Whole thread Raw
In response to PRIMARY KEY and indexes  ("Craig Bryden" <postgresql@bryden.co.za>)
Responses Re: PRIMARY KEY and indexes  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
On Sat, Apr 23, 2005 at 11:45:43AM +0200, Craig Bryden wrote:

> 2. How do I create a clustered index in postgres?

There is no such thing as a clustered index in Postgres.  You can order
the table itself following an index (that's what CLUSTER does), but you
don't get the data itself inside the index, which is what AFAIK a
clustered index in other database systems.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"¿Cómo puedes confiar en algo que pagas y que no ves,
y no confiar en algo que te dan y te lo muestran?" (Germán Poo)

pgsql-general by date:

Previous
From: "Brian Maguire"
Date:
Subject: Pgpool questions
Next
From: Thomas F.O'Connell
Date:
Subject: Re: Table modifications with dependent views - best practices?