Grzegorz Jaœkiewicz<gryz...@gmail.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.
 
-Kevin

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to