Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id B87242E004C for ; Fri, 4 Apr 2008 04:32:30 -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 40972-01 for ; Fri, 4 Apr 2008 04:32:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from tyo202.gate.nec.co.jp (TYO202.gate.nec.co.jp [202.32.8.206]) by developer.postgresql.org (Postfix) with ESMTP id 00BA52E0038 for ; Fri, 4 Apr 2008 04:32:26 -0300 (ADT) Received: from mailgate3.nec.co.jp (mailgate54.nec.co.jp [10.7.69.195]) by tyo202.gate.nec.co.jp (8.13.8/8.13.4) with ESMTP id m347WOxk007447 for ; Fri, 4 Apr 2008 16:32:24 +0900 (JST) Received: (from root@localhost) by mailgate3.nec.co.jp (8.11.7/3.7W-MAILGATE-NEC) id m347WOv08424 for pgsql-admin@postgresql.org; Fri, 4 Apr 2008 16:32:24 +0900 (JST) Received: from togyo.jp.nec.com (togyo.jp.nec.com [10.26.220.4]) by mailsv.nec.co.jp (8.13.8/8.13.4) with ESMTP id m347WOan014868 for ; Fri, 4 Apr 2008 16:32:24 +0900 (JST) Received: from C07AUG23723 ([10.72.28.19] [10.72.28.19]) by mail.jp.nec.com with ESMTP; Fri, 4 Apr 2008 16:32:23 +0900 Message-Id: <014601c89626$065d4a80$131c480a@nsl.ad.nec.co.jp> From: "Duan Ligong" To: References: <011101c89609$eaa96060$131c480a@nsl.ad.nec.co.jp> <47F5C8D7.9070904@nsoft.lt> Subject: Re: store different tables in different locations Date: Fri, 4 Apr 2008 16:32:23 +0900 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="UTF-8"; reply-type=response Content-Transfer-Encoding: 8bit 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=AWL=0.001, MSOE_MID_WRONG_CASE=0.699 X-Spam-Level: X-Archive-Number: 200804/36 X-Sequence-Number: 28800 Julius Tuskenis wrote: > Hello, > 1) To store tables in different locations use different tablespaces, witch > can be stored in different locations in your hard drive. Same goes for the > databases. Thanks a lot and it would be helpful. :) I am a newbie to postgresql and maybe I should read the manuual first. > 2) > a) Postgresql is fine data base management system, so I see no reasons why > you should not use it. we use postgresql to store so little data as only 600MB or so, while for this, we have to do consume some efforts on managing and maintaining the database. I am not sure whether it is a good and wise design. Is there any more wiser design for this case? > b) I'm not sure I fully understand you on that one. You want to estimate, > that after inserting some record into your database it will reach your > maximum size? Any way I don't know how to do this... For some reason the size of database is asked to restrict to 900MB. So I have to make efforts to make sure that its size is less than 900MB. Maybe I should not do it. :) Thanks a lot Duan > Duan Ligong rašė: >> 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 differentlocations >> 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 >> > > > -- > Julius Tuskenis > Programuotojas > UAB nSoft > mob. +37068233050 > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >