Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X4FTi-0006PT-T5 for pgsql-admin@arkaria.postgresql.org; Mon, 07 Jul 2014 20:25:35 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1X4FTh-0003aQ-TQ for pgsql-admin@arkaria.postgresql.org; Mon, 07 Jul 2014 20:25:33 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1X4FTc-0003PL-23; Mon, 07 Jul 2014 20:25:28 +0000 Received: from mail.savoirfairelinux.com ([209.172.62.77]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X4FTY-00029l-MO; Mon, 07 Jul 2014 20:25:26 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.savoirfairelinux.com (Postfix) with ESMTP id 291B410D7452; Mon, 7 Jul 2014 16:25:23 -0400 (EDT) X-Virus-Scanned: amavisd-new at mail.savoirfairelinux.com Received: from mail.savoirfairelinux.com ([127.0.0.1]) by localhost (mail.savoirfairelinux.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id lNcbVfA42i-W; Mon, 7 Jul 2014 16:25:22 -0400 (EDT) Received: from mail.savoirfairelinux.com (mail.savoirfairelinux.com [192.168.52.6]) by mail.savoirfairelinux.com (Postfix) with ESMTP id 4834310D7450; Mon, 7 Jul 2014 16:25:22 -0400 (EDT) Date: Mon, 7 Jul 2014 16:25:22 -0400 (EDT) From: Nicolas Zin To: Mike Christensen Cc: pgsql-admin@postgresql.org, Forums postgresql , Prabhjot Sheena Message-ID: <1428392174.230588.1404764722248.JavaMail.root@mail> In-Reply-To: Subject: Re: [GENERAL] WARNING: database must be vacuumed within 8439472 transactions MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Mailer: Zimbra 7.1.4_GA_2555 (ZimbraWebClient - FF3.0 (Linux)/7.1.4_GA_2555) X-Pg-Spam-Score: -0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Maybe you can priorize your worker with a ionice? ----- Mail original ----- De: "Mike Christensen" =C3=80: "Prabhjot Sheena" Cc: pgsql-admin@postgresql.org, "Forums postgresql" Envoy=C3=A9: Lundi 7 Juillet 2014 16:15:18 Objet: Re: [ADMIN] [GENERAL] WARNING: database must be vacuumed within 8439= 472 transactions Sounds like you just have to wait until it finishes..=20 On Mon, Jul 7, 2014 at 12:56 PM, Prabhjot Sheena < prabhjot.sheena@rivalwat= ch.com > wrote:=20 Hello=20 We are using postgresql 8.3 database for last 5 yrs for this production dat= abase and its running fine. This is our critical database which runs 24*7. = This weekend we started getting these messages=20 HINT: To avoid a database shutdown, execute a full-database VACUUM.=20 WARNING: database must be vacuumed within 8439472 transactions=20 i am currently running this command=20 vacuumdb --analyze db=20 while this command is running i m still getting these messages=20 WARNING: database must be vacuumed within 2645303 transactions.=20 The value of number of transactions is going down every minute=20 Can anyone tell me what is the best way to sort up this issue.=20 Thanks=20 Avi=20 --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin