Reclaiming used disk space

From: Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr>
To: pgsql-admin(at)postgresql(dot)org
Subject: Reclaiming used disk space
Date: 2006-05-19 11:51:39
Message-ID: 1148039500.19658.18.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)splivalo(at)mobart(dot)hr

"I can do it quick, I can do it cheap, I can do it well. Pick any two."

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2006-05-19 12:26:33 Re: does wal archiving block the current client connection?
Previous Message Tom Lane 2006-05-18 20:27:54 Re: lock a database from new connections, without modifying pg_hba.conf