X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 67D4B9F9AFD for ; Fri, 19 May 2006 08:51:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 45670-04 for ; Fri, 19 May 2006 08:51:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pjetlic.mobart.hr (pjetlic.mobart.hr [80.80.51.10]) by postgresql.org (Postfix) with ESMTP id DEB5D9FA372 for ; Fri, 19 May 2006 08:51:46 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by pjetlic.mobart.hr (Postfix) with ESMTP id 6C9FD17D70 for ; Fri, 19 May 2006 13:51:43 +0200 (CEST) Received: from pjetlic.mobart.hr ([127.0.0.1]) by localhost (pjetlic [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 20231-06-5 for ; Fri, 19 May 2006 13:51:43 +0200 (CEST) Received: from mike.mobart.hr (mike.mobart.hr [192.168.10.94]) (using SSLv3 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by pjetlic.mobart.hr (Postfix) with ESMTP id 4BD3C17AB8 for ; Fri, 19 May 2006 13:51:43 +0200 (CEST) Subject: Reclaiming used disk space From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: pgsql-admin@postgresql.org Content-Type: text/plain Organization: Mob-Art Date: Fri, 19 May 2006 13:51:39 +0200 Message-Id: <1148039500.19658.18.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by OpenSource AV+AS Mail Server X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/270 X-Sequence-Number: 21802 I was doing some tests, while doing so I needed to enter some 100.000.000 records in a table. That took almost one GB of disk space, df -kh shows I have some 130 MB of free disk space. I did dropdb on that test database, but empty space still shows 130 MB. How can I reclaim (reget?) space used by test database? Mario -- Mario Splivalo Mob-Art mario.splivalo@mobart.hr "I can do it quick, I can do it cheap, I can do it well. Pick any two."