Re: Contrib reindex script:
От | Fran Fabrizio |
---|---|
Тема | Re: Contrib reindex script: |
Дата | |
Msg-id | 3CD991A4.2050506@mmrd.com обсуждение исходный текст |
Ответ на | Re: Contrib reindex script: (Shaun Thomas <sthomas@townnews.com>) |
Список | pgsql-general |
Just want to say thanks for the reindex script. Today I used it as the basis of a perl script which I've cron'ed and produces a daily report of table/index name and size for all tables/indexes in my db so I can see if things are growing out of control. Thanks to this new tool, I found several out of control indexes. One example: I had a 55 megabyte index which reduced to 44k. Overall, I reduced my db size from 550 megs to 300. Additionally, the web interface which this database is powering is much more responsive. We have several high-turnover tables. We have one of only about 1500 rows but which experiences nearly 100% turnover every 5 minutes. As a first-time PostgreSQL administrator, I've been nagging myself to figure out a way to monitor db growth in this manner. Of course, there was always something else to work on at the time. Thanks again, Fran
В списке pgsql-general по дате отправления: