Re: store different tables in different locations

Поиск
Список
Период
Сортировка
От Julius Tuskenis
Тема Re: store different tables in different locations
Дата
Msg-id 47F5E12B.70701@nsoft.lt
обсуждение исходный текст
Ответ на Re: store different tables in different locations  ("Duan Ligong" <l-duan@zd.cnes.jp.nec.com>)
Ответы Re: store different tables in different locations  (Shane Ambler <pgsql@Sheeky.Biz>)
Список pgsql-admin
> 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.


В списке pgsql-admin по дате отправления:

Предыдущее
От: Thomas Bräutigam
Дата:
Сообщение: Re: Postgres and SUN
Следующее
От: Marc Cousin
Дата:
Сообщение: cannot restore a view after a dump