"Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)bg> writes:
> the idea of ALTER INDEX ...REBUILD/COALESCE is that the index is optimised
> without accessing the table, so it should be faster
If you feel a compelling need to have a variant of REINDEX that works
that way, feel free to write it. It seems like an extremely
low-priority concern to me, though. (No, I'm not convinced there's
much performance gain to be had there, either...)
regards, tom lane