From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Prabhjot Sheena <prabhjot.sheena@rivalwatch.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Cc: Forums postgresql <pgsql-general@postgresql.org>
Subject: Re: WARNING: database must be vacuumed within 8439472 transactions
Date: Mon, 7 Jul 2014 16:51:03 -0400
Message-ID: <20140707205103.GH6390@eldon.alvh.no-ip.org> (raw)
In-Reply-To: <CAOf_bQbs9Y1AVv8YUjtHoYmdSzVAaBzqLdy+4126y-nyLo5hLA@mail.gmail.com>
References: <CAOf_bQZdiQFrQtvyh5SCzQc63GZWYt=D=oOu4f2mgBKVAO9tEA@mail.gmail.com>
<20140707203144.GG6390@eldon.alvh.no-ip.org>
<CAOf_bQbs9Y1AVv8YUjtHoYmdSzVAaBzqLdy+4126y-nyLo5hLA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
Prabhjot Sheena wrote:
> While the vacuumdb --analyze command is running i m getting these messages
> for these tables which might require full vacuum.
>
> WARNING: relation "public.result" contains more than "max_fsm_pages" pages
> with useful free space
> HINT: Consider using VACUUM FULL on this relation or increasing the
> configuration parameter "max_fsm_pages".
Ouch. I had read you were on 9.3 in your first email, but this message
gives me a trip back in time a decade ago -- you're on 8.3! Clearly you
have had vacuuming issues for a long time.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@2ndquadrant.com, prabhjot.sheena@rivalwatch.com, pgsql-general@postgresql.org
Subject: Re: WARNING: database must be vacuumed within 8439472 transactions
In-Reply-To: <20140707205103.GH6390@eldon.alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox