VACUUM/VACUUM FULL/REINDEX - Mailing list pgsql-admin

From Sam Barnett-Cormack
Subject VACUUM/VACUUM FULL/REINDEX
Date
Msg-id Pine.LNX.4.50.0308010955350.6415-100000@short.lancs.ac.uk
Whole thread Raw
Responses Re: VACUUM/VACUUM FULL/REINDEX
List pgsql-admin
I'm a little confused about comments I've seen on this list - a VACUUM
is not enough, clearly, to maintain a trim, efficient DB. People have
mentioned that REINDEX is also needed periodically. Is this the case
even if one VACUUM FULL's periodically, or does that effectively REINDEX
also?

--

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University

pgsql-admin by date:

Previous
From: Sam Barnett-Cormack
Date:
Subject: Re: Partitioning tables...
Next
From: Mauri Sahlberg
Date:
Subject: Re: Parallel transactions failing oddly