| From: | Marcin Mirosław <marcin(at)mejor(dot)pl> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: : Performance Improvement Strategy |
| Date: | 2011-09-20 17:51:36 |
| Message-ID: | 4E78D2A8.9090709@mejor.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
W dniu 2011-09-20 18:22, Venkat Balaji pisze:
> 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 ?
Hello!
I hope this link will be usefull for you :
http://wiki.postgresql.org/wiki/Show_database_bloat
Regards
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2011-09-20 18:09:48 | Re: : Performance Improvement Strategy |
| Previous Message | Thomas Kappler | 2011-09-20 17:43:27 | Slow query with self-join, group by, 100m rows |