Postgres Pro
Downloads
Home   >   mailing lists

Re: What are the benefits of using a clustered index? - Mailing list pgsql-general

From Simon Riggs
Subject Re: What are the benefits of using a clustered index?
Date
Msg-id 1237296727.3953.103.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: What are the benefits of using a clustered index?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: What are the benefits of using a clustered index?  (Mike Christensen <imaudi@comcast.net>)
Re: What are the benefits of using a clustered index?  (Scott Ribe <scott_ribe@killerbytes.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: c k
Date:
Subject: Re: different results for large objects
Next
From: Stephen Frost
Date:
Subject: Re: PostgreSQL versus MySQL for GPS Data