From: Julius Tuskenis <julius@nsoft.lt>
Cc: pgsql-admin@postgresql.org
Subject: Re: store different tables in different locations
Date: Fri, 04 Apr 2008 11:04:59 +0300
Message-ID: <47F5E12B.70701@nsoft.lt> (raw)
In-Reply-To: <014601c89626$065d4a80$131c480a@nsl.ad.nec.co.jp>
References: <011101c89609$eaa96060$131c480a@nsl.ad.nec.co.jp>
<47F5C8D7.9070904@nsoft.lt>
<014601c89626$065d4a80$131c480a@nsl.ad.nec.co.jp>
> 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?
In my case postgresql is like "fire and forget". Once installed it needs
to be vacuumed regularly. Thats all. Well, backups also. What
maintenance do you do?
> 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. :)
It depends on how much data you want to store. You said you have 400
machines in the network, so 900Mb limits you to ~2Mb per machine. You
decide if thats enough.
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: julius@nsoft.lt
Subject: Re: store different tables in different locations
In-Reply-To: <47F5E12B.70701@nsoft.lt>
* 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