Well, so I need to do reindex frequentely in database? Is that right? Or should I use cluster, as David said? How frequently should I do this operation?
---------------------
Not necessarily. If there is no table or index bloat, which you should be able to check first, - why bother?
Normally autovacuum does pretty good job even with default configuration parameters. If not, you could start with adjusting autovacuum parameters. And reindex only as a last resort, when your index size grows "uncontrollably". Igor Neyman
