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>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: What are the benefits of using a clustered index?
Date: 2009-03-20 15:53:18
Message-ID: C5E9180E.B3A6C%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Just think one index tuple points to more than one heap row. We would
> still need to check visibility on the rows returned to ensure MVCC.

So you wind up with the heap rows stored in their own tree-like structure
outside the index? OK.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Will Rutherdale (rutherw) 2009-03-20 15:55:40 Re: Is there a meaningful benchmark?
Previous Message Simon Riggs 2009-03-20 15:48:51 Re: What are the benefits of using a clustered index?