X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3AD5DD1D896 for ; Mon, 24 Nov 2003 17:14:47 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 70645-07 for ; Mon, 24 Nov 2003 13:14:15 -0400 (AST) Received: from trade-india.com (ns5.trade-india.com [66.234.10.13]) by svr1.postgresql.org (Postfix) with SMTP id 50841D1D86A for ; Mon, 24 Nov 2003 13:14:14 -0400 (AST) Received: (qmail 18307 invoked from network); 24 Nov 2003 17:14:58 -0000 Received: from unknown (HELO busybox.trade-india.com) (203.145.130.142) by ns5.trade-india.com with SMTP; 24 Nov 2003 17:14:58 -0000 From: Rajesh Kumar Mallah Organization: Trade-India.com To: pgsql-performance@postgresql.org Subject: VACUUM problems with 7.4 Date: Mon, 24 Nov 2003 22:43:59 +0530 User-Agent: KMail/1.5.3 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200311242243.59296.mallah@trade-india.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/208 X-Sequence-Number: 4768 I am sure there is no transaction open with the table banner_stats2. Still VACUUM FULL does not seems to effective in removing the dead rows. Can any one please help? Regds mallah tradein_clients=# VACUUM FULL verbose banner_stats2 ; INFO: vacuuming "public.banner_stats2" INFO: "banner_stats2": found 0 removable, 741912 nonremovable row versions in 6710 pages DETAIL: 737900 dead row versions cannot be removed yet. Nonremovable row versions range from 61 to 72 bytes long. There were 120 unused item pointers. Total free space (including removable row versions) is 246672 bytes. 0 pages are or will become empty, including 0 at the end of the table. 557 pages containing 61344 free bytes are potential move destinations. CPU 0.15s/1.23u sec elapsed 1.38 sec. INFO: index "banner_stats_pkey" now contains 741912 row versions in 2173 pages DETAIL: 0 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.03s/0.05u sec elapsed 0.09 sec. INFO: "banner_stats2": moved 0 row versions, truncated 6710 to 6710 pages DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec. VACUUM tradein_clients=#