Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 069F0B5DC17 for ; Wed, 21 Sep 2011 09:21:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 19068-07 for ; Wed, 21 Sep 2011 12:21:40 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from relay-7.dlfw.twtelecom.net (relay-7.dlfw.twtelecom.net [216.136.82.76]) by mail.postgresql.org (Postfix) with ESMTP id CE57FB5DC13 for ; Wed, 21 Sep 2011 09:21:39 -0300 (ADT) Received: from localhost (unknown [127.0.0.1]) by relay-7.dlfw.twtelecom.net (Postfix) with ESMTP id E27F258099 for ; Wed, 21 Sep 2011 06:21:34 -0600 (MDT) X-Virus-Scanned: amavisd-new at twtelecom.net Received: from relay-7.dlfw.twtelecom.net ([127.0.0.1]) by localhost (relay-7.dlfw.twtelecom.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id AKuL0mxB8Rjc for ; Wed, 21 Sep 2011 06:21:32 -0600 (MDT) Received: from mailblocker.ateb.com (unknown [97.65.140.200]) by relay-7.dlfw.twtelecom.net (Postfix) with ESMTP id 917A658088 for ; Wed, 21 Sep 2011 06:21:32 -0600 (MDT) X-IronPort-AV: E=Sophos;i="4.68,417,1312171200"; d="scan'208";a="344317" Received: from unknown (HELO sr002-2k3exc.ateb.com) ([172.16.48.228]) by mailblocker.ateb.com with SMTP; 21 Sep 2011 08:21:32 -0400 Received: from [172.16.48.2] ([172.16.48.2] RDNS failed) by sr002-2k3exc.ateb.com with Microsoft SMTPSVC(6.0.3790.4675); Wed, 21 Sep 2011 08:21:31 -0400 Subject: Re: REINDEX not working for wastedspace From: Reid Thompson Reply-To: Reid.Thompson@ateb.com To: AI Rumman Cc: reid.thompson@ateb.com, pgsql-performance@postgresql.org Date: Wed, 21 Sep 2011 08:21:20 -0400 In-Reply-To: References: Organization: Ateb, Inc Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.1.90 Content-Transfer-Encoding: 7bit Message-ID: <1316607691.17526.60.camel@raker.ateb.com> Mime-Version: 1.0 X-OriginalArrivalTime: 21 Sep 2011 12:21:32.0023 (UTC) FILETIME=[FF28F070:01CC7858] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201109/312 X-Sequence-Number: 45088 On Wed, 2011-09-21 at 13:01 +0600, AI Rumman wrote: > I am using Postgresql 9.0.1. > > I REINDEXED both the indexes and table, but I did not find any change > in wastedspace or wastedispace. > Could you please tell me why? you need to 1) either vacuum full or cluster the table 2) analyze the table 3) check bloat again