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
|
Список | 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 по дате отправления: