| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Greg Smith <gsmith(at)gregsmith(dot)com>, Phillip Berry <pberry(at)stellaconcepts(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Startup process thrashing |
| Date: | 2008-12-11 13:27:04 |
| Message-ID: | 20081211132704.GD3807@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
> Greg Smith <gsmith(at)gregsmith(dot)com> writes:
> > Not exactly. What it said was "To avoid a database shutdown, execute a
> > full-database VACUUM". In that context, "full" means you vacuum
> > everything in the database, but only regular VACUUM is needed. VACUUM
> > FULL, as you learned the hard way, is a more intensive operation, and it's
> > not needed to resolve the problem you started with. It's a somewhat
> > unfortunately worded HINT.
>
> Maybe we could rephrase it as "whole-database VACUUM"?
"database-wide VACUUM"?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-12-11 13:36:11 | Re: Startup process thrashing |
| Previous Message | Tom Lane | 2008-12-11 13:19:34 | Re: Startup process thrashing |