Skip site navigation (1) Skip section navigation (2)

Re: "Compacting" a relation

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: "Compacting" a relation
Date: 2007-02-04 03:11:12
Message-ID: 200702040311.l143BCU10198@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > vacuumlazy.c contains a hint "Consider compacting this relation" but AFAICT, 
> > there is no indication anywhere how "compacting" is supposed to be achieved.
> > I guess this means VACUUM FULL or CLUSTER, but I don't think the hint can be 
> > processed effectively by a user.
> 
> So change it ...

New message is:

  errhint("Consider using VACUUM FULL on this relation or increasing the configuration parameter \"max_fsm_pages\".")));

-- 
  Bruce Momjian   bruce(at)momjian(dot)us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2007-02-04 03:55:52
Subject: pgsql: Add documentation for Windows on how to set an environment
Previous:From: Bruce MomjianDate: 2007-02-04 02:54:38
Subject: Re: this patch correct upper and lower case for translated month's and day's names

pgsql-patches by date

Next:From: Simon RiggsDate: 2007-02-04 09:25:18
Subject: Re: Remove log segment and log_id fields from pg_controldata
Previous:From: Bruce MomjianDate: 2007-02-04 02:54:38
Subject: Re: this patch correct upper and lower case for translated month's and day's names

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group