Re: More Praise for 7.4RC2

It should be the number of pages in the relation. A page is usually 8K
unless it's changed. Not sure how often it's updated though.

On Fri, Nov 14, 2003 at 03:02:49PM -0700, Rick Gigger wrote:
> 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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato