From: Greg Smith <greg@2ndquadrant.com>
To: raghavendra t <raagavendra.rao@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to fast the REINDEX
Date: Thu, 01 Apr 2010 07:36:54 -0400
Message-ID: <4BB48556.2030406@2ndquadrant.com> (raw)
In-Reply-To: <p2ubc7de5a31003311351p83987eedpbb86727ab9fa9ca3@mail.gmail.com>
References: <p2ubc7de5a31003311351p83987eedpbb86727ab9fa9ca3@mail.gmail.com>
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@2ndQuadrant.com www.2ndQuadrant.us
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@2ndquadrant.com, raagavendra.rao@gmail.com
Subject: Re: How to fast the REINDEX
In-Reply-To: <4BB48556.2030406@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox