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@xxxxxxxxxxxxxxxx ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
