: Performance Improvement Strategy

Поиск
Список
Период
Сортировка
От Venkat Balaji
Тема : Performance Improvement Strategy
Дата
Msg-id CAFrxt0j5UysgEU8hQxZ_mGbdex8Ev-bGdGsdpOGYYSO-jO24Fw@mail.gmail.com
обсуждение исходный текст
Ответы Re: : Performance Improvement Strategy  (Marcin Mirosław <marcin@mejor.pl>)
Re: : Performance Improvement Strategy  (Josh Berkus <josh@agliodbs.com>)
Re: : Performance Improvement Strategy  (Shaun Thomas <sthomas@peak6.com>)
Список pgsql-performance
Дерево обсуждения
Hello Everyone,

I had  posted  a query in "GENERAL" category, not sure if that was the correct category to post.

Please help me understand how to calculate free space in Tables and Indexes even after vacuuming and analyzing is performed.

What i understand is that, even if we perform VACUUM ANALYZE regularly, the free space generated is not filled up.

I see lot of free spaces or free pages in Tables and Indexes. But, I need to give an exact calculation on how much space will be reclaimed after VACUUM FULL and RE-INDEXING.

Is there any standard procedure or process to calculate the same ?

Please help !

Thanks
Venkat

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Hash index use presently(?) discouraged since 2005: revive or bury it?