Re: More Praise for 7.4RC2

>>>>> "RG" == Rick Gigger <rick(at)alpinenetworking(dot)com> writes:

RG> Are there any guidelines on how often one should do a reindex?

regularly monitor your index sizes with a query such as this:

SELECT relname,relpages FROM pg_class WHERE relname LIKE 'user_list%' ORDER BY relname;

On my most busy tables, index bloat in PG 7.2 is horrendous. I have
one index that more than triples in size after about 10 days. After
reindex it gets to a respectable 22k relpages.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/