| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | louis nguyen | 2004-03-30 23:56:54 | Re: what is the impact of Database size on Performemce |
| Previous Message | Erland Sommarskog | 2004-03-30 21:48:10 | Re: what is the impact of Database size on Performemce |