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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
