X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AB66ED1E9B1 for ; Tue, 30 Mar 2004 22:17:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 17598-05 for ; Tue, 30 Mar 2004 18:17:17 -0400 (AST) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id B3065D1E8AB for ; Tue, 30 Mar 2004 18:17:13 -0400 (AST) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.10/8.12.10) with ESMTP id i2UMFx2M011940; Tue, 30 Mar 2004 15:15:59 -0700 (MST) Date: Tue, 30 Mar 2004 15:11:22 -0700 (MST) From: "scott.marlowe" To: Juan Miguel Cc: Subject: Re: Deleting a database In-Reply-To: <4069D96C.5000001@ono.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-IHS-MailScanner-Envelope-Sender: scott.marlowe@ihs.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/395 X-Sequence-Number: 12964 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.