Re: [previously on HACKERS] "Compacting" a relation - Mailing list pgsql-patches

Bruce Momjian wrote:
>
> I applied the optional VACUUM FULL version, but modified to code to say
> 20% rather than a factor of 5, attached.

String construction does not work well with translations; please
reformulate this.

> +                  errhint("Consider%sincreasing the configuration parameter \"max_fsm_pages\".",
> +                         /* Only suggest VACUUM FULL if 20% free */
> +                         (vacrelstats->tot_free_pages > vacrelstats->rel_pages * 0.20
> +                             ? " using VACUUM FULL on this relation or ": " "))));


--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support