Skip site navigation (1) Skip section navigation (2)

Re: Reindex database

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Greg Spiegelberg <gspiegelberg(at)cranel(dot)com>
Cc: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Reindex database
Date: 2003-12-12 15:54:05
Message-ID: Pine.LNX.4.33.0312120851460.16496-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, 12 Dec 2003, Greg Spiegelberg wrote:

> Any rule of thumb for REINDEX DATABASE?  Once per month?
> Per x transactions?

You shouldn't need to reindex databases for the most part.  If there's 
lots of catalog updates / delete, it might be occasionally useful to down 
the database and reindex those catalogs in single user mode since you 
can't reindex them on a live database if I remember correctly.

If you are running 7.3.5 or before, you might need to schedule daily /
weekly / monthly etc reindexes of indexes that show unreasonable growth 
problems.  This should be mostly fixed for 7.4, and reindexes should not 
really be needed anymore, we hope :-).

generally speaking, reindex is for fixing broken indexes, not generaly 
maintenance.


In response to

pgsql-admin by date

Next:From: Sai Hertz And Control SystemsDate: 2003-12-12 16:06:08
Subject: Tables Without OIDS and its effect
Previous:From: scott.marloweDate: 2003-12-12 15:48:14
Subject: Re: ODBC Driver generates a too big "windows swap file" and

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group