| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-02-04 03:55:52 | pgsql: Add documentation for Windows on how to set an environment |
| Previous Message | Bruce Momjian | 2007-02-04 02:54:38 | Re: this patch correct upper and lower case for translated month's and day's names |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-02-04 09:25:18 | Re: Remove log segment and log_id fields from pg_controldata |
| Previous Message | Bruce Momjian | 2007-02-04 02:54:38 | Re: this patch correct upper and lower case for translated month's and day's names |