I understand that 'cluster' performs the role of defrag (along with rewriting in index order) in Postgres. How frequently does one have to run cluster ? Any thumb-rules or experience ? How do I find if my table is fragmented enough to need a cluster ? We are still to use Postgres in production, just evaluating at this point.
Thanks for any pointers.
