Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id D20602E004C for ; Fri, 4 Apr 2008 00:00:15 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 61223-01 for ; Fri, 4 Apr 2008 00:00:06 -0300 (ADT) X-Greylist: delayed 00:17:08.099814 by SQLgrey-1.7.5 Received: from tyo200.gate.nec.co.jp (TYO200.gate.nec.co.jp [210.143.35.50]) by developer.postgresql.org (Postfix) with ESMTP id 864122E0049 for ; Fri, 4 Apr 2008 00:00:05 -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 m342h0ir027493 for ; Fri, 4 Apr 2008 11:43:01 +0900 (JST) Received: from mailgate4.nec.co.jp ([10.7.69.184]) by tyo201.gate.nec.co.jp (8.13.8/8.13.4) with ESMTP id m342ZYtb010036 for ; Fri, 4 Apr 2008 11:35:34 +0900 (JST) Received: (from root@localhost) by mailgate4.nec.co.jp (8.11.7/3.7W-MAILGATE-NEC) id m342ZY024730 for pgsql-admin@postgresql.org; Fri, 4 Apr 2008 11:35:34 +0900 (JST) Received: from kaishu.jp.nec.com (kaishu.jp.nec.com [10.26.220.5]) by mailsv4.nec.co.jp (8.13.8/8.13.4) with ESMTP id m342ZYQk028928 for ; Fri, 4 Apr 2008 11:35:34 +0900 (JST) Received: from C07AUG23723 ([10.72.28.19] [10.72.28.19]) by mail.jp.nec.com with ESMTP; Fri, 4 Apr 2008 11:35:33 +0900 Message-Id: <00d301c895fc$8eb3bba0$131c480a@nsl.ad.nec.co.jp> From: "Duan Ligong" To: Subject: store different tables in different locations Date: Fri, 4 Apr 2008 11:35:32 +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: 200804/45 X-Sequence-Number: 28809 Hi, all I have several questions to bother you. :) 1 For postgresql, is it POSSIBLE to store different tables in different locations where we specify? For one postgresql management process, is it POSSIBLE to store different database in different locations where we specify? 2 Is it appropriate to use Postgresql to store data for the following situation: The whole system consists of about 400 machines and I have to develop a program collecting the information about capacity and performance and networt setting and so on of each machines and displaying them for the administrators and some related guys. Moreover, I have to store some history data to display graphes and curvers. My design is as follows: one daemon process running on each machine to collect data and send it to the database which is in one specified machine. The bad thing is that the size of database is asked to be resricted in 900MB for some reasons. The questions are: (a) Is it appropriate to use postgresql database in this case? If not, any sugguestion will be appreciated. In fact considered using common file to store data. but you know, it is possible that daemon processes on other 399 machines send data simultaneously, ... (b) It seems hard to estimate the maximum size of the database, because frequently updating and inserting opreations will cause unused space not acclaiming in time and we have to routinely vaccum. Is there any good and easy, :) way to estimate the maximum size of postgresql database accurately? Best regards, Duan -- Duan Ligong TEL : 0561-75-1925-6201 800-81-569-6201 E-Mail : l-duan@zd.cnes.jp.nec.com