Re: Deleting a database - Mailing list pgsql-admin

From scott.marlowe
Subject Re: Deleting a database
Date
Msg-id Pine.LNX.4.33.0403301504530.22721-100000@css120.ihs.com
Whole thread Raw
In response to Deleting a database  (Juan Miguel <juanmime@ono.com>)
List 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.


pgsql-admin by date:

Previous
From: Manuel Sugawara
Date:
Subject: Re: tweaking scan.l
Next
From: "Eduardo Sachwek Fontanetti"
Date:
Subject: Accessing Linux Postgre Server from windows client