Sizing of LARGE databases.

Поиск
Список
Период
Сортировка
От Michael Miyabara-McCaskey
Тема Sizing of LARGE databases.
Дата
Msg-id 000c01c08b3c$b5d72b90$c700a8c0@ncc1701e
обсуждение исходный текст
Список pgsql-general
Hello there,

I have a DB that I am attempting to buy "the right hardware" for.

This DB today is about 25GB total, with typical tables in the area of 3GB in
size, and up to about 20 million records per table for the big tables.

Is there any set of recommendations for sizing a DB using PostgreSQL?  (I
have all the docs but have not found anything of any use).

This DB itself will be mostly reads, for a decision system.  However, there
will be a lot more data added in the future where the DB could easily grow
to about 150GB in size, and up to about 60millions records for the large
tables.

My current setup is Linux RH7 w/PostgreSQL 7.0.2, my intention is to build a
large array of Linux Clusters, but I also can not find any documentation on
how if at all PostgreSQL handles a clustered environment.  (Although I did
see something that said you could have multiple "databases" and use a create
view to stich together multiple tables from different DBs in a HOWTO on the
www.kernel.org/LDP I have also noticed that the doc is longer there, and
people who have posted about how to do this on these forums have been told
this method does not work).

Any thoughts would be greatly appreciated.

Michael Miyabara-McCaskey
Email: mykarz@miyabara.com
Web: http://www.miyabara.com/mykarz/
Mobile: +1 408 504 9014



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

Предыдущее
От: "Michael Miyabara-McCaskey"
Дата:
Сообщение: Queries against multi-million record tables.
Следующее
От: Justin Clift
Дата:
Сообщение: Re: Sizing of LARGE databases.