From: Nicolas Zin <nicolas.zin@savoirfairelinux.com>
To: Mike Christensen <mike@kitchenpc.com>
Cc: pgsql-admin@postgresql.org, Forums postgresql <pgsql-general@postgresql.org>
Cc: Prabhjot Sheena <prabhjot.sheena@rivalwatch.com>
Subject: Re: [GENERAL] WARNING: database must be vacuumed within 8439472 transactions
Date: Mon, 7 Jul 2014 16:25:22 -0400 (EDT)
Message-ID: <1428392174.230588.1404764722248.JavaMail.root@mail> (raw)
In-Reply-To: <CABs1bs0vexoRkrPGj7Mor0yFvEp48p_noSSWoV0i5xDn2ORggw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Maybe you can priorize your worker with a ionice?
----- Mail original -----
De: "Mike Christensen" <mike@kitchenpc.com>
À: "Prabhjot Sheena" <prabhjot.sheena@rivalwatch.com>
Cc: pgsql-admin@postgresql.org, "Forums postgresql" <pgsql-general@postgresql.org>
Envoyé: Lundi 7 Juillet 2014 16:15:18
Objet: Re: [ADMIN] [GENERAL] WARNING: database must be vacuumed within 8439472 transactions
Sounds like you just have to wait until it finishes..
On Mon, Jul 7, 2014 at 12:56 PM, Prabhjot Sheena < prabhjot.sheena@rivalwatch.com > wrote:
Hello
We are using postgresql 8.3 database for last 5 yrs for this production database and its running fine. This is our critical database which runs 24*7. This weekend we started getting these messages
HINT: To avoid a database shutdown, execute a full-database VACUUM.
WARNING: database must be vacuumed within 8439472 transactions
i am currently running this command
vacuumdb --analyze db
while this command is running i m still getting these messages
WARNING: database must be vacuumed within 2645303 transactions.
The value of number of transactions is going down every minute
Can anyone tell me what is the best way to sort up this issue.
Thanks
Avi
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: nicolas.zin@savoirfairelinux.com, mike@kitchenpc.com, pgsql-general@postgresql.org, prabhjot.sheena@rivalwatch.com
Subject: Re: [GENERAL] WARNING: database must be vacuumed within 8439472 transactions
In-Reply-To: <1428392174.230588.1404764722248.JavaMail.root@mail>
* 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