Re: issue log message to suggest VACUUM FULL if a table is nearly empty - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: issue log message to suggest VACUUM FULL if a table is nearly empty
Date
Msg-id CAA4eK1+3jZ0+4jb2N22pqV7qBBkwnp01TVHAbLGDbiWj04r1cQ@mail.gmail.com
Whole thread Raw
In response to Re: issue log message to suggest VACUUM FULL if a table is nearly empty  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Responses Re: issue log message to suggest VACUUM FULL if a table is nearly empty
List pgsql-hackers
On Wed, Mar 12, 2014 at 12:22 PM, Haribabu Kommi
<kommi.haribabu@gmail.com> wrote:
> On Tue, Mar 11, 2014 at 2:59 PM, Amit Kapila <amit.kapila16@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



pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: requested shared memory size overflows size_t
Next
From: "Prabakaran, Vaishnavi"
Date:
Subject: Providing catalog view to pg_hba.conf file - Patch submission