Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 8E2819FB418 for ; Wed, 1 Aug 2007 10:03:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 81149-10 for ; Wed, 1 Aug 2007 10:03:17 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 679649FB3DF for ; Wed, 1 Aug 2007 10:03:22 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1IGDr7-0008Uu-7v for pgsql-admin@postgresql.org; Wed, 01 Aug 2007 15:03:13 +0200 Received: from pirus.securax.be ([213.16.46.130]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 01 Aug 2007 15:03:13 +0200 Received: from milen by pirus.securax.be with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 01 Aug 2007 15:03:13 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: Raw disk space used Date: Wed, 01 Aug 2007 16:03:02 +0300 Lines: 19 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: pirus.securax.be User-Agent: Thunderbird 2.0.0.5 (Windows/20070716) In-Reply-To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/2 X-Sequence-Number: 26333 Carol Walter написа: > Hi, Guys, > > Is there a way to tell what the raw disk space used by a single database > is? I know that databases are fluid, but if there is way to do even a > snap shot view that is a "ball park" figure, I'd be happy. My user > keeps clammering for this figure. > Depending on what you mean by "raw disk space" the "pg_database_size" function (mentioned here - http://www.postgresql.org/docs/current/static/functions-admin.html) will give you this information. -- Milen A. Radev