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

From Alvaro Herrera
Subject Re: PRIMARY KEY and indexes
Date
Msg-id 20050423154953.GC25846@dcc.uchile.cl
Whole thread Raw
In response to Re: PRIMARY KEY and indexes  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
On Sat, Apr 23, 2005 at 08:45:25AM -0700, Joshua D. Drake wrote:
> Alvaro Herrera wrote:
> >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.
>
> I believe this is being worked on for 8.1 yes?

I haven't heard of such a thing ...  Maybe the bizgres people wants to
do that.  But it's hard to do so I wouldn't expect a usable
implementation for 8.1 if they are just starting.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"I personally became interested in Linux while I was dating an English major
who wouldn't know an operating system if it walked up and bit him."
(Val Henson)

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Playing with PostgreSQL and Access VBA
Next
From: Alvaro Herrera
Date:
Subject: Re: Pgpool questions