Re: PRIMARY KEY and indexes

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Craig Bryden <postgresql(at)bryden(dot)co(dot)za>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: PRIMARY KEY and indexes
Date: 2005-04-23 15:27:04
Message-ID: 20050423152704.GB25846@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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[(at)]dcc(dot)uchile(dot)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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F.O'Connell 2005-04-23 15:36:00 Re: Table modifications with dependent views - best practices?
Previous Message Brian Maguire 2005-04-23 14:41:00 Pgpool questions