Postgres Pro
Downloads
Home   >   mailing lists

Thread: size of the database

size of the database

From
"Zoran muljevski"
Date:

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

Re: size of the database

From
"Kevin Grittner"
Date:
"Zoran muljevski" <muljevski@gmail.com> 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