Grzegorz Jaœkiewicz<gryzman(at)gmail(dot)com> wrote:
> Other way, is to perform regular cluster && reindex
If you CLUSTER there is no reason to REINDEX; indexes are rebuilt by the CLUSTER command.
Also, if you do a good job with regular VACUUMs, there isn't any bloat to fix. In that case a regular CLUSTER would only be needed if it was worth the cost to keep data physically organized in the index sequence.