Re: cluster index on a table

From: Justin Pitts <justinpitts(at)gmail(dot)com>
To: Scott Carey <scott(at)richrelevance(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, Ibrahim Harrani <ibrahim(dot)harrani(at)gmail(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Subject: Re: cluster index on a table
Date: 2009-07-16 17:52:58
Message-ID: C7B97E83-D09C-4247-A1CD-24EB8817ADC8@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

ISTR that is the approach that MSSQL follows.

>
> Storing the full tuple in an index and not even having a data only
> page
> would also be an interesting approach to this (and perhaps simpler
> than a
> separate index file and data file if trying to keep the data in the
> order of
> the index).

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message William Scott Jordan 2009-07-16 17:56:47 Incr/Decr Integer
Previous Message Scott Carey 2009-07-16 17:35:15 Re: cluster index on a table