On Wed, Mar 12, 2014 at 12:22 PM, Haribabu Kommi <kommi.harib...@gmail.com> wrote: > On Tue, Mar 11, 2014 at 2:59 PM, Amit Kapila <amit.kapil...@gmail.com> wrote: > >> By the way have you checked if FreeSpaceMapVacuum() can serve your >> purpose, because this call already traverses FSM in depth-first order to >> update the freespace. So may be by using this call or wrapper on this >> such that it returns total freespace as well apart from updating freespace >> can serve the need. > > Thanks for information. we can get the table free space by writing some > wrapper > or modify a little bit of FreeSpaceMapVacuum() function.
I think it might be okay to even change this API to return the FreeSpace, as the other place it is used is for Index Vacuum, so even if we don't have any intention to print such a message for index in this patch, but similar information could be useful there as well to suggest a user that index has lot of free space. With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
