Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 172569FA19B for ; Wed, 6 Dec 2006 15:55:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 43335-03 for ; Wed, 6 Dec 2006 15:55:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id AF73C9F9386 for ; Wed, 6 Dec 2006 15:55:29 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kB6JtRVN000555; Wed, 6 Dec 2006 14:55:27 -0500 (EST) To: asif ali cc: pgsql-performance@postgresql.org Subject: Re: VACUUM FULL does not works....... In-reply-to: <427904.83683.qm@web58403.mail.re3.yahoo.com> References: <427904.83683.qm@web58403.mail.re3.yahoo.com> Comments: In-reply-to asif ali message dated "Wed, 06 Dec 2006 10:37:20 -0800" Date: Wed, 06 Dec 2006 14:55:27 -0500 Message-ID: <554.1165434927@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/144 X-Sequence-Number: 22200 asif ali writes: > INFO: vacuuming "public.product_table" > INFO: "product_table": found 0 removable, 139178 nonremovable row versions in 4305 pages > DETAIL: 138859 dead row versions cannot be removed yet. So Scott's guess was correct: you've got a whole lot of dead rows in there that will eventually be removable, but not while there's still an open transaction that might be able to "see" them. Find your open transaction and get rid of it (pg_stat_activity might help). regards, tom lane