raghavendra t wrote:
1. What are the parameters will effect, when issuing the REINDEX command 2. Best possible way to increase the spead of the REINDEX
If you haven't done the usual general tuning on your server, that might help. http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server is an introduction. If increasing maintainance_work_mem alone doesn't help, I'd try increases to checkpoint_segments and then shared_buffers next. Those are the three parameters mostly likely to speed that up.
The things already suggested in this thread are still valid though. Needing to REINDEX suggests there may be a problem with your database better addressed by running autovacuum more regularly.
-- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
