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

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>, 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-20 15:33:33
Message-ID: C5E9136D.B3A53%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Wouldn't this require keeping around multiple versions of index pages for
MVCC? Which would create performance degradations elsewhere?

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-03-20 15:37:07 Re: Srf function : missing library on PostgreSQL 8.3.6 on Windows?
Previous Message Scott Ribe 2009-03-20 15:27:21 Re: Is there a meaningful benchmark?