From: | "Rick Gigger" <rick(at)alpinenetworking(dot)com> |
---|---|
To: | "Vivek Khera" <khera(at)kcilink(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: More Praise for 7.4RC2 |
Date: | 2003-11-14 22:02:49 |
Message-ID: | 00c001c3aafb$0c542460$0700a8c0@trogdor |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)kcilink(dot)com>
Newsgroups: ml.postgres.general
To: <pgsql-general(at)postgresql(dot)org>
Sent: Friday, November 14, 2003 2:21 PM
Subject: Re: [GENERAL] 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/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Glenn Wiorek | 2003-11-14 22:04:59 | Re: YOUR SITES SEARCH FEATURE DOES NOT WORK! |
Previous Message | Nick Fankhauser | 2003-11-14 21:51:38 | Re: YOUR SITES SEARCH FEATURE DOES NOT WORK! |