Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id A80B32E005F for ; Wed, 21 May 2008 22:13:20 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 30582-06 for ; Wed, 21 May 2008 22:13:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from tyo200.gate.nec.co.jp (TYO200.gate.nec.co.jp [210.143.35.50]) by developer.postgresql.org (Postfix) with ESMTP id 9EE5F2E0031 for ; Wed, 21 May 2008 22:13:08 -0300 (ADT) Received: from tyo201.gate.nec.co.jp ([10.7.69.201]) by tyo200.gate.nec.co.jp (8.13.8/8.13.4) with ESMTP id m4M1D0Ok014926 for ; Thu, 22 May 2008 10:13:06 +0900 (JST) Received: from mailgate3.nec.co.jp (mailgate53A.nec.co.jp [10.7.69.192]) by tyo201.gate.nec.co.jp (8.13.8/8.13.4) with ESMTP id m4M18afJ019287; Thu, 22 May 2008 10:08:36 +0900 (JST) Received: (from root@localhost) by mailgate3.nec.co.jp (8.11.7/3.7W-MAILGATE-NEC) id m4M18ac17438; Thu, 22 May 2008 10:08:36 +0900 (JST) Received: from saigo.jp.nec.com (saigo.jp.nec.com [10.26.220.6]) by mailsv4.nec.co.jp (8.13.8/8.13.4) with ESMTP id m4M18ajJ024873; Thu, 22 May 2008 10:08:36 +0900 (JST) Received: from C07AUG23723 ([10.72.35.246] [10.72.35.246]) by mail.jp.nec.com with ESMTP; Thu, 22 May 2008 10:08:34 +0900 Message-Id: <00ba01c8bba8$5b402750$f623480a@nsl.ad.nec.co.jp> From: "Duan Ligong" To: "Scott Marlowe" Cc: References: <004301c8b62b$b183e840$f623480a@nsl.ad.nec.co.jp> Subject: Re: ]To estimate the size of db Date: Thu, 22 May 2008 10:08:33 +0900 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.7 tagged_above=0 required=5 tests=MSOE_MID_WRONG_CASE=0.699, STOX_REPLY_TYPE=0.001 X-Spam-Level: X-Archive-Number: 200805/181 X-Sequence-Number: 29265 Hi, Scott Thanks for your reply. > There's also the old fashioned way: I mean I want to estimate the size of the space which the db will occupy. Now there is no db. > sudo su - postgres > cd $PGDATA # or wherever you point with -D on startup > du -sh . Regards Duan -- Duan Ligong TEL : 0561-75-1925-6201 800-81-569-6201 E-Mail : l-duan@zd.cnes.jp.nec.com ----- Original Message ----- From: "Scott Marlowe" To: "Duan Ligong" Cc: Sent: Thursday, May 22, 2008 4:08 AM Subject: Re: [ADMIN] [Admin]To estimate the size of db > On Wed, May 14, 2008 at 7:33 PM, Duan Ligong > wrote: >> >> Hi, all >> >> Is there a way to estimate the size of the space which a postgresql >> database >> occupies? or the max size of db? >> >> I know there are a lot of factors, such as the frequency >> of updating, data size, which affects the size of db and it seems >> difficult >> to estimate it precisely. > > There's also the old fashioned way: > > sudo su - postgres > cd $PGDATA # or wherever you point with -D on startup > du -sh . > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >