Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X4HrF-00064y-T0 for pgsql-general@arkaria.postgresql.org; Mon, 07 Jul 2014 22:58:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1X4HrF-0004PR-Cc for pgsql-general@arkaria.postgresql.org; Mon, 07 Jul 2014 22:58:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1X4HrD-0004NR-Pq for pgsql-general@postgresql.org; Mon, 07 Jul 2014 22:57:59 +0000 Received: from hogranch.com ([75.101.82.47]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X4Hr9-0005Q1-TY for pgsql-general@postgresql.org; Mon, 07 Jul 2014 22:57:58 +0000 Received: from [192.168.0.2] (porker [192.168.0.2]) by hogranch.com (8.11.6/8.11.6) with ESMTP id s67MvjZ12401 for ; Mon, 7 Jul 2014 15:57:45 -0700 Message-ID: <53BB25E4.5080400@hogranch.com> Date: Mon, 07 Jul 2014 15:57:40 -0700 From: John R Pierce User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Re: [ADMIN] WARNING: database must be vacuumed within 8439472 transactions References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-HawgScanner-Information: Please contact the ISP for more information X-HawgScanner: Found to be clean X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org On 7/7/2014 2:14 PM, Prabhjot Sheena wrote: > i will run full vacuum than and see how it goes. do make sure there aren't any OLD pending transactions hanging around. if you have any stalled client connections that have left a transaction open for weeks/months, vacuum can't free any tuples newer than the oldest transaction. select * from pg_stat_activity where xact_start < now()-interval '1 hour'; will list all connections with transactions over 1 hour old. -- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general