Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c7hsL-000650-Dj for pgsql-admin@arkaria.postgresql.org; Fri, 18 Nov 2016 12:02:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1c7hsK-0002Vk-SF for pgsql-admin@arkaria.postgresql.org; Fri, 18 Nov 2016 12:02:36 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1c7hqd-0000a5-Oq for pgsql-admin@postgresql.org; Fri, 18 Nov 2016 12:00:51 +0000 Received: from mwork.nabble.com ([162.253.133.43]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c7hqb-0001xm-Gc for pgsql-admin@postgresql.org; Fri, 18 Nov 2016 12:00:50 +0000 Received: from mben.nabble.com (unknown [162.253.133.72]) by mwork.nabble.com (Postfix) with ESMTP id 35BED6D341F31 for ; Fri, 18 Nov 2016 05:00:49 -0700 (MST) Date: Fri, 18 Nov 2016 05:00:49 -0700 (MST) From: rajan To: pgsql-admin@postgresql.org Message-ID: <1479470449084-5930937.post@n3.nabble.com> Subject: vacuum full is not reclaiming the space and showing non-removable rows MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.3 (/) 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 Hi, vacuum full verbose chnges_23_21; INFO: vacuuming "public.chnges_23_21" INFO: "chnges_23_21": found 0 removable, 8602500 nonremovable row versions in 88699 pages DETAIL: 8436850 dead row versions cannot be removed yet. CPU 0.61s/3.38u sec elapsed 5.45 sec. VACUUM We deleted(using a delete query) a lot of rows from the above table and did a vacuum full. But we are not able to reclaim the space(occupied by this table) and the result is showing that there are nonremovable rows. Can anyone help on how it can be fixed? ----- -- Thanks, Rajan. -- View this message in context: http://postgresql.nabble.com/vacuum-full-is-not-reclaiming-the-space-and-showing-non-removable-rows-tp5930937.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin