| From: | Venkat Balaji <venkat(dot)balaji(at)verse(dot)in> |
|---|---|
| To: | PGSQL Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | : Performance Improvement Strategy |
| Date: | 2011-09-20 16:22:42 |
| Message-ID: | CAFrxt0j5UysgEU8hQxZ_mGbdex8Ev-bGdGsdpOGYYSO-jO24Fw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-09-20 16:25:19 | Re: Hash index use presently(?) discouraged since 2005: revive or bury it? |
| Previous Message | Merlin Moncure | 2011-09-20 16:11:28 | Re: Hash index use presently(?) discouraged since 2005: revive or bury it? |