pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Deleting 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