Re: routine reindexing in 7.4.6/8.0?

Vivek Khera <khera@kcilink.com>

From: Vivek Khera <khera@kcilink.com>
To: pgsql-general@postgresql.org
Date: 2004-11-04T20:08:20Z
Lists: pgsql-general
>>>>> "EL" == Ed L <pgsql@bluepolka.net> writes:

EL> What is the conventional wisdom about routine reindexing with
EL> 7.4.6 and 8.0?  Is it still considered an important maintenance
EL> task?  If so, how frequently is it needed?

I haven't seen a need to reindex since upgrading from 7.2 to 7.4.
Under 7.2, I needed to reindex once per month or so.


-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD  +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/