Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 6936E2E003A for ; Wed, 14 May 2008 23:46:40 -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 33786-03 for ; Wed, 14 May 2008 23:46:31 -0300 (ADT) X-Greylist: delayed 01:03:33.312111 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 4F2492E0035 for ; Wed, 14 May 2008 23:46:37 -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 m4F1h0rE002104 for ; Thu, 15 May 2008 10:43:01 +0900 (JST) Received: from mailgate3.nec.co.jp (mailgate53D.nec.co.jp [10.7.69.160]) by tyo201.gate.nec.co.jp (8.13.8/8.13.4) with ESMTP id m4F1Xcj2028861 for ; Thu, 15 May 2008 10:33:39 +0900 (JST) Received: (from root@localhost) by mailgate3.nec.co.jp (8.11.7/3.7W-MAILGATE-NEC) id m4F1XcQ28803 for pgsql-admin@postgresql.org; Thu, 15 May 2008 10:33:38 +0900 (JST) Received: from kuichi.jp.nec.com (kuichi.jp.nec.com [10.26.220.17]) by mailsv4.nec.co.jp (8.13.8/8.13.4) with ESMTP id m4F1XcON000159 for ; Thu, 15 May 2008 10:33:38 +0900 (JST) Received: from C07AUG23723 ([10.72.35.246] [10.72.35.246]) by mail.jp.nec.com with ESMTP; Thu, 15 May 2008 10:33:36 +0900 Message-Id: <004301c8b62b$b183e840$f623480a@nsl.ad.nec.co.jp> From: "Duan Ligong" To: Subject: [Admin]To estimate the size of db Date: Thu, 15 May 2008 10:33:35 +0900 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-2022-jp"; 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/132 X-Sequence-Number: 29216 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. Regards Duan -- TEL : 0561-75-1925-6201 800-81-569-6201 E-Mail : l-duan@zd.cnes.jp.nec.com