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 по дате отправления: