Re: More Praise for 7.4RC2

Поиск
Список
Период
Сортировка
От Rick Gigger
Тема Re: More Praise for 7.4RC2
Дата
Msg-id 00c001c3aafb$0c542460$0700a8c0@trogdor
обсуждение исходный текст
Ответ на Re: More Praise for 7.4RC2  ("scott.marlowe" <scott.marlowe@ihs.com>)
Ответы Re: More Praise for 7.4RC2  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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@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
>


В списке pgsql-general по дате отправления:

Предыдущее
От: Dmitry Tkach
Дата:
Сообщение: What are these files about?
Следующее
От: jini us
Дата:
Сообщение: Re: embedded postgresql + C++ IDE