Re: When does CLUSTER occur?

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@optionshouse.com

______________________________________________

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