Postgres Pro
Downloads
Home   >   mailing lists

Reclaiming used disk space - Mailing list pgsql-admin

From Mario Splivalo
Subject Reclaiming used disk space
Date
Msg-id 1148039500.19658.18.camel@localhost.localdomain
Whole thread Raw
List pgsql-admin
Tree view 
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."

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: lock a database from new connections, without modifying pg_hba.conf
Next
From: Simon Riggs
Date:
Subject: Re: does wal archiving block the current client connection?