From: Josh Berkus <josh@agliodbs.com>
To: Shankar K <shan0075@yahoo.com>
To: pgsql-performance@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [PERFORM] Rebuild indexes
Date: Mon, 28 Jul 2003 17:18:59 -0700
Message-ID: <200307281718.59127.josh@agliodbs.com> (raw)
In-Reply-To: <20030728212905.79549.qmail@web21102.mail.yahoo.com>
References: <20030728212905.79549.qmail@web21102.mail.yahoo.com>
Shankar,
> Is there a better way to do this. comments are
> appreciated.
No. This is one of the major features in 7.4; FSM and VACUUM will manage
indexes as well. Until then, we all suffer ....
BTW, the REINDEX command is transaction-safe. So if your database has "lull"
periods, you can run it without worrying that any updates will get turned
back.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, shan0075@yahoo.com, pgsql-admin@postgresql.org
Subject: Re: [PERFORM] Rebuild indexes
In-Reply-To: <200307281718.59127.josh@agliodbs.com>
References: <20030728212905.79549.qmail@web21102.mail.yahoo.com> <200307281718.59127.josh@agliodbs.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