| From: | "Kevin Grittner" <kgrittn(at)mail(dot)com> |
|---|---|
| To: | "Igor Neyman" <ineyman(at)perceptron(dot)com>,"Mike Christensen" <mike(at)kitchenpc(dot)com>,sthomas(at)optionshouse(dot)com |
| Cc: | "Jeff Janes" <jeff(dot)janes(at)gmail(dot)com>,"Schnabel, Robert D(dot)" <schnabelr(at)missouri(dot)edu>,pgsql-general(at)postgresql(dot)org |
| Subject: | Re: When does CLUSTER occur? |
| Date: | 2012-11-29 19:55:17 |
| Message-ID: | 20121129195517.69330@gmx.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Keller | 2012-11-29 20:07:30 | Storing files in the database - and giving easy access to this? |
| Previous Message | Serge Fonville | 2012-11-29 19:53:50 | Re: When does CLUSTER occur? |