Skip site navigation (1) Skip section navigation (2)

Re: Deleting a database

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Juan Miguel <juanmime(at)ono(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Deleting a database
Date: 2004-03-30 22:11:22
Message-ID: Pine.LNX.4.33.0403301504530.22721-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, 30 Mar 2004, Juan Miguel wrote:

> This is a little question :
> 
> In postgres, "delete database dbsample", frees the disk space used for 
> this DB?, or I have to drop the files manually ?
> I wondered this question, because I read that when you delete records, 
> you must run vacuum for freeing the space.

the whole database instance is dropped, no need to clean up. Same is true 
for dropped tables, indexes, or any other complete object like that.

The only thing vacuum recovers is space within an object, like deleted 
tuples or index entries.


In response to

pgsql-admin by date

Next:From: louis nguyenDate: 2004-03-30 23:56:54
Subject: Re: what is the impact of Database size on Performemce
Previous:From: Erland SommarskogDate: 2004-03-30 21:48:10
Subject: Re: what is the impact of Database size on Performemce

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group