Re: More Praise for 7.4RC2

What exactly does that number (relpages) mean?  It seems that my large
tables and indexes have large values for relpages and and small tables and
indexes have small values.

rg

----- Original Message -----
From: "Vivek Khera" <khera@kcilink.com>
Newsgroups: ml.postgres.general
To: <pgsql-general@postgresql.org>
Sent: Friday, November 14, 2003 2:21 PM
Subject: Re: [GENERAL] More Praise for 7.4RC2


> >>>>> "RG" == Rick Gigger <rick@alpinenetworking.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@kciLink.com       Rockville, MD       +1-240-453-8497
> AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>