Re: When does CLUSTER occur?

From: Shaun Thomas <sthomas(at)optionshouse(dot)com>
To: Mike Christensen <mike(at)kitchenpc(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" <pgsql-general(at)postgresql(dot)org>
Subject: Re: When does CLUSTER occur?
Date: 2012-11-29 17:33:05
Message-ID: 50B79C51.5070904@optionshouse.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/29/2012 11:28 AM, Mike Christensen wrote:

> It's always kinda annoyed me that the CLUSTER command in Postgres
> doesn't work like it does on Microsoft SQL.

It's a natural side-effect of MVCC, unfortunately. Data goes wherever it
goes according to the free space map, or at the end if there are no free
blocks in the table.

I guess that's one thing rollback segments are good for. In-place
modifications of data so order can be maintained.

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas(at)optionshouse(dot)com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaun Thomas 2012-11-29 17:41:44 Re: youtube video on pgsql integrity
Previous Message Mike Christensen 2012-11-29 17:28:26 Re: When does CLUSTER occur?