Christopher Kings-Lynne wrote:
> > 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).
It will slow down other index scans only if there was some clustering on
those indexes before you ran the CLUSTER command.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026