Re: When does CLUSTER occur? - Mailing list pgsql-general

From Kevin Grittner
Subject Re: When does CLUSTER occur?
Date
Msg-id 20121129195517.69330@gmx.com
Whole thread Raw
In response to When does CLUSTER occur?  ("Schnabel, Robert D." <schnabelr@missouri.edu>)
List pgsql-general
Igor Neyman wrote:

> As for MS SQL, here is how it implements clustering:
> The index on which the table is clustered actually becomes a
> "physical holder" (for the lack of better term) of the table,
> meaning the complete table tuples are stored in the leaf blocks
> of the index it is clustered on. There is no other place in the
> database where they are stored physically.

Right, in a SQL Server clustered table the data row is stored in
the leaf level of the clustered index, and in PostgreSQL we don't
store tuple visibility information within any index; so we would
have a fair amount of work to do before we could use a similar
approach.

-Kevin


pgsql-general by date:

Previous
From: Serge Fonville
Date:
Subject: Re: When does CLUSTER occur?
Next
From: Stefan Keller
Date:
Subject: Storing files in the database - and giving easy access to this?