Alvaro Herrera wrote: > Alvaro Herrera wrote: >Probably most of the time is going into creating the new table then. > >If you are looking for a short-term solution to your problem, maybe the >best is to follow the recommendation on CLUSTER ref page:
I've read that section before, but I have lots of foreign key relationships between the tables. Thanks Alvaro and Tom, but it seems that I will have to live with that behaviour, until ... >No, the ALTER TABLE/CLUSTER ON only defines what index will the table be >clustered on in the future, but it doesn't cluster it at that time. >Perhaps it could be improved so that if a table rewrite is going to be >done anyway for some other reason, then make sure the rewrite uses the >cluster order. I think it's far from trivial though. ... this has been tried. Rainer ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
