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

Simon Riggs <simon@2ndQuadrant.com> writes:

> Just think one index tuple points to more than one heap row.

Could you expand on that? Like, uh, I have no idea what you're saying.

> Less index pointers, smaller index.

Are you talking about Heikkie's grouped-items-index?

> The trick is: How? But that's a secondary issue to getting it on the
> TODO list, which is all I'm suggesting at present.

Well I think we need to be clear enough at least on the "what" if not the
"how". But there's a bit a of a fuzzy line between them I admit.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's RemoteDBA services!