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