From muljevski@gmail.com Tue Dec 21 17:41:24 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 06B001337B63 for ; Tue, 21 Dec 2010 13:41:24 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 85701-09 for ; Tue, 21 Dec 2010 17:41:13 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f49.google.com (mail-fx0-f49.google.com [209.85.161.49]) by mail.postgresql.org (Postfix) with ESMTP id 32C8E1337B5B for ; Tue, 21 Dec 2010 13:41:12 -0400 (AST) Received: by fxm19 with SMTP id 19so4421616fxm.22 for ; Tue, 21 Dec 2010 09:41:12 -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=Q/BLwJJVRJ6jScsoXauq5ZqoCvdk9U89RZgmd1d5ZAs=; b=bdz0qqMHvguLRNP2nxPj71zd5ReZkvLeWRp81qJf5yDeVjpreGXuyAKiIHpm0H1WyV dX8Yfy7Xi/5XxglRlMBOWzK3lilI1a6JO/oV2JOcHu9VTzYWsayQJpp2qJWd6KgGTTsY 2J/HwWf0WCxoF8CmN0B0HXgEan1G1+HOxhZkE= 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=bmcdLYW9UXDbnOr+a96hbLFjzZ5e8betgIl6qv0TA17ZzF0zS78nkYmEXzQg/hsb1e m5vLS1Bwpc75xMDkQ5VgxfqmoG53O6P8liF5OGqZSQ0mEC7IrthWY1zYxNUPeyAAYi1e MjHkgK1hsocsf6yk/ooi8A4eO1+dLZXTgkx4k= Received: by 10.223.86.65 with SMTP id r1mr6330264fal.24.1292953272010; Tue, 21 Dec 2010 09:41:12 -0800 (PST) Received: from muljevski (93-87-152-64.dynamic.isp.telekom.rs [93.87.152.64]) by mx.google.com with ESMTPS id k6sm1413415faa.30.2010.12.21.09.41.09 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 21 Dec 2010 09:41:11 -0800 (PST) From: "Zoran muljevski" To: Subject: size of the database Date: Tue, 21 Dec 2010 18:41:10 +0100 Message-ID: <000001cba136$4372e420$ca58ac60$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01CBA13E.A5374C20" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcudHHJ7FcPJtu5rRu+GthiJun2ySg== Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.699 tagged_above=-10 required=5 tests=BAYES_40=-0.001, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201012/148 X-Sequence-Number: 36377 This is a multipart message in MIME format. ------=_NextPart_000_0001_01CBA13E.A5374C20 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Database PostgreSQL 8.1.22 takes 2 GB. I deleted a table of 300 MB. But the database still takes up 2 GB. I deleted the indexes of 200 MB but the base still has 2 GB. What should I do? Thank you, Muljevski Zoran ------=_NextPart_000_0001_01CBA13E.A5374C20 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Database PostgreSQL 8.1.22 takes 2 GB. I deleted a table of 300 MB. But the database still takes up 2 GB. I deleted = the indexes of 200 MB but the base still has 2 GB.
What should I = do?

Thank you,

Muljevski Zoran

------=_NextPart_000_0001_01CBA13E.A5374C20-- From Kevin.Grittner@wicourts.gov Tue Dec 21 17:54:00 2010 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id C2A881337B63 for ; Tue, 21 Dec 2010 13:54:00 -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 28609-09 for ; Tue, 21 Dec 2010 17:53:53 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id 9B3FE1337B5B for ; Tue, 21 Dec 2010 13:53:52 -0400 (AST) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Tue, 21 Dec 2010 11:53:52 -0600 Message-Id: <4D10954602000025000388C8@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Tue, 21 Dec 2010 11:53:42 -0600 From: "Kevin Grittner" To: "Zoran muljevski" , Subject: Re: size of the database References: <000001cba136$4372e420$ca58ac60$@com> In-Reply-To: <000001cba136$4372e420$ca58ac60$@com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.21 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/150 X-Sequence-Number: 36379 "Zoran muljevski" wrote: > Database PostgreSQL 8.1.22 takes 2 GB. I deleted a table of 300 > MB. But the database still takes up 2 GB. I deleted the indexes of > 200 MB but the base still has 2 GB. > What should I do? What is your OS? How are you measuring this? -Kevin