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

On Wed, 2007-02-21 at 21:28 -0300, Alvaro Herrera wrote:
> 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: point noted for future. Bruce: many thanks.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com