Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5F0E11337B5D for ; Tue, 30 Nov 2010 13:27:02 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 53158-01 for ; Tue, 30 Nov 2010 17:26:55 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yw0-f46.google.com (mail-yw0-f46.google.com [209.85.213.46]) by mail.postgresql.org (Postfix) with ESMTP id DF7401335B36 for ; Tue, 30 Nov 2010 13:26:54 -0400 (AST) Received: by ywl5 with SMTP id 5so2855215ywl.19 for ; Tue, 30 Nov 2010 09:26:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:subject:date :message-id:mime-version:content-type:x-mailer:thread-index :content-language; bh=meeBH1hgE6UBhY86kXg3j/sS91tyLCrX73l9WU5fnRo=; b=F2IhzE9OyvQbeU4WIQ4x1SJJ0rKS4TMKTd1C1rVluzNaKMcMg4Soc+JwsW4dxlsrv5 O3Mg/8as5XzBuoSwBb+iA/SDVjhtUz271JO015tlqTBTyhjkl1XJqA764fjbjboQOxPj zkgypaigMYcCzWG79WcXcyO6fievBhVEeuGr4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:subject:date:message-id:mime-version:content-type:x-mailer :thread-index:content-language; b=jeQ1Kpj0/9VDfebTgvT2AQve1PkJBkUs72gdLnQN//v3T6wXyVak7F9T9rRaDy5Jl9 afGppSAKTeXqbq5CMZmo+ScCxe9Ru+M23quKLBQDtDeygQYII5Ybx6vgkc0i9KOJA7ux F1/s5PZB25CJ59ZplkGe40AMuGzCQkz5E80RE= Received: by 10.204.119.84 with SMTP id y20mr1123504bkq.56.1291138013842; Tue, 30 Nov 2010 09:26:53 -0800 (PST) Received: from 345bf1f2bc8c491 ([114.143.126.120]) by mx.google.com with ESMTPS id a24sm588445fak.1.2010.11.30.09.26.50 (version=SSLv3 cipher=RC4-MD5); Tue, 30 Nov 2010 09:26:52 -0800 (PST) From: "Shridhar Polas" To: Subject: Space occupied by Postgres index. Date: Tue, 30 Nov 2010 22:56:53 +0530 Message-ID: <00b901cb90b3$ca9ddc40$5fd994c0$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00BA_01CB90E1.E4561840" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AcuQsw+yg9h1Em6bSyaC2ApcpXViHA== Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201011/257 X-Sequence-Number: 36223 This is a multipart message in MIME format. ------=_NextPart_000_00BA_01CB90E1.E4561840 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Hi, I am facing a problem where indexes creates on some tables are occupying huge space on disk and it seems to me that this space is not getting reclaimed even when there are very few record in an associated table. When I ran full vacuum the disk space was reclaimed occupied by tables but not by disk space occupied by indexes. Can somebody please tell me when disk space occupied by Postgres index is reclaimed, without performing re-indexing on those tables? Thanks, Shridhar ------=_NextPart_000_00BA_01CB90E1.E4561840 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Hi,

 

I am facing = a problem where indexes creates on some tables are occupying huge space = on disk and it seems to me that this space is not getting reclaimed even = when there are very few record in an associated table.

 

When I ran = full vacuum the disk space was reclaimed occupied by tables but not by = disk space occupied by indexes.

 

Can somebody = please tell me when disk space occupied by Postgres index is reclaimed, = without performing re-indexing on those tables?

 

Thanks,

Shridhar

------=_NextPart_000_00BA_01CB90E1.E4561840--