Thread

1. routine reindexing in 7.4.6/8.0?

   Ed L. <pgsql@bluepolka.net> — 2004-11-02T02:18:21Z

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

2. Re: routine reindexing in 7.4.6/8.0?

   Joshua D. Drake <jd@commandprompt.com> — 2004-11-02T02:55:14Z

   Ed L. wrote:
   
   >What is the conventional wisdom about routine reindexing with 7.4.6 and 8.0?  
   >Is it still considered an important maintenance task?  If so, how 
   >frequently is it needed?
   >  
   >
   
   7.4 at least handles a lot of the reindex issues at vacuum time.
   I assume 8 does the same.
   
   Sincerely,
   
   Joshua D. Drake
   
   
   >Ed
   >
   >
   >---------------------------(end of broadcast)---------------------------
   >TIP 4: Don't 'kill -9' the postmaster
   >  
   >
   
   
   -- 
   Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
   Postgresql support, programming shared hosting and dedicated hosting.
   +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
   PostgreSQL Replicator -- production quality replication for PostgreSQL
   
   

3. Re: routine reindexing in 7.4.6/8.0?

   Vivek Khera <khera@kcilink.com> — 2004-11-04T20:08:20Z

   >>>>> "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/