| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | raghavendra t <raagavendra(dot)rao(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: How to fast the REINDEX |
| Date: | 2010-04-01 11:36:54 |
| Message-ID: | 4BB48556.2030406@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Faheem Mitha | 2010-04-01 11:46:40 | Re: experiments in query optimization |
| Previous Message | Steve Clark | 2010-04-01 11:10:13 | Re: How to fast the REINDEX |