pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Duan Ligong <l-duan@zd.cnes.jp.nec.com>
To: pgsql-admin@postgresql.org
Subject: store different tables in different locations
Date: Fri, 4 Apr 2008 13:11:11 +0900
Message-ID: <011101c89609$eaa96060$131c480a@nsl.ad.nec.co.jp> (raw)

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 




view thread (7+ messages)  latest in thread

Message-ID: <011101c89609$eaa96060$131c480a@nsl.ad.nec.co.jp>
Permalink:  ../011101c89609$eaa96060$131c480a@nsl.ad.nec.co.jp/
Also on:    postgresql.org/message-id/011101c89609$eaa96060$131c480a@nsl.ad.nec.co.jp

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: l-duan@zd.cnes.jp.nec.com
  Subject: Re: store different tables in different locations
  In-Reply-To: <011101c89609$eaa96060$131c480a@nsl.ad.nec.co.jp>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox