Greg Stark <gsst...@mit.edu> wrote: > I don't think we want to cluster on the primary key. I think we just > want to rewrite the table keeping the same physical ordering. Well if that's what you want to do, couldn't you do something like?: Lock the table. Prop all indexes Pass the heap with two pointers, one to the first available empty space and one to the first non-dead row past that, and move inside the existing file. Rebuild the indexes. Release the lock. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
