Re: [previously on HACKERS] "Compacting" a relation

Bruce Momjian wrote:
> Alvaro Herrera wrote:
> > 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 ": " "))));
>
> OK, updated.

Thanks :-)


--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.