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

From Simon Riggs
Subject Re: [previously on HACKERS] "Compacting" a relation
Date
Msg-id 1172141954.3874.95.camel@silverbirch.site
Whole thread Raw
In response to Re: [previously on HACKERS] "Compacting" a relation  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-patches
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



pgsql-patches by date:

Previous
From: Gregory Stark
Date:
Subject: [test]
Next
From: Teodor Sigaev
Date:
Subject: Re: First implementation of GIN for pg_trgm