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