Re: What are the benefits of using a clustered index?

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Mike Christensen <imaudi(at)comcast(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: What are the benefits of using a clustered index?
Date: 2009-03-17 13:32:07
Message-ID: 1237296727.3953.103.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Tue, 2009-03-17 at 09:16 -0400, Alvaro Herrera wrote:
> > I'm quite sure SQL Server doesn't work this way and I'm not sure
> about
> > Oracle. Can someone enlighten me on the exact benefit of this?
> Thanks!!
>
> Yeah, they use a completely different definition of "clustered index"
> from ours.

Hopefully we regard it as a missing feature rather than as a separate
definition. We could cluster the index, we just don't, yet.

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2009-03-17 13:56:14 Re: PostgreSQL versus MySQL for GPS Data
Previous Message c k 2009-03-17 13:27:35 Re: [GENERAL] different results for large objects