> Clustering on one index doesn't decrease the performance of the other
> indexes. Also, only >=7.3 will preserve all indexes during cluster.
Sure it must? Since you are rearranging all on-disk rows to match a
particular index (say user_id, username) then it will slow down other
indexes (eg one just on username).
Chris
