pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDeleting a database
2+ messages / 2 participants
[nested] [flat]
* Deleting a database
@ 2004-03-30 20:32 Juan Miguel <juanmime@ono.com>
0 siblings, 1 reply; 2+ messages in thread
From: Juan Miguel @ 2004-03-30 20:32 UTC (permalink / raw)
To: pgsql-admin
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.
Thanks.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Deleting a database
@ 2004-03-30 22:11 scott.marlowe <scott.marlowe@ihs.com>
parent: Juan Miguel <juanmime@ono.com>
0 siblings, 0 replies; 2+ messages in thread
From: scott.marlowe @ 2004-03-30 22:11 UTC (permalink / raw)
To: Juan Miguel <juanmime@ono.com>; +Cc: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-03-30 22:11 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-30 20:32 Deleting a database Juan Miguel <juanmime@ono.com>
2004-03-30 22:11 ` scott.marlowe <scott.marlowe@ihs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox