store different tables in different locations

From: "Duan Ligong" <l-duan(at)zd(dot)cnes(dot)jp(dot)nec(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: store different tables in different locations
Date: 2008-04-04 04:11:11
Message-ID: 011101c89609$eaa96060$131c480a@nsl.ad.nec.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)zd(dot)cnes(dot)jp(dot)nec(dot)com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Julius Tuskenis 2008-04-04 06:21:11 Re: store different tables in different locations
Previous Message Duan Ligong 2008-04-04 02:35:32 store different tables in different locations