Sizing a box for PostgreSQL
От | Francisco Reyes |
---|---|
Тема | Sizing a box for PostgreSQL |
Дата | |
Msg-id | 20011121222049.P79598-100000@zoraida.natserv.net обсуждение исходный текст |
Список | pgsql-novice |
I have been doing some "unoficial" work with PostgreSQL and I may be able to make PostgreSQL official (ie. use it for production work). The question my boss threw at me was: what kind of box do we need? How would I go about properly sizing a machine to run PostgreSQL? There would be about half a dozen tables. The biggest is about 7.5 million records on the rest of the tables are less than a million each. I don't know if I will have to use one of the existing servers or if I will get $$$ to buy a new one. If I get $$$ I will try to get 4 X 15RPM on Raid 5with 1GB of memory and 1GH cpu. If there is no money then I will properly get an old server (one possible seems is a 500Mz cpu with 10K rpm drives and Raid). We literally have HOURS to run these reports, but there are numerous reports. My boss is concerned whether we would be able to run them. Right now we use about about 10 Foxpro machines to run the reports and other nightly cleanups. On my favor is the fact that I would be able to create whatever index I need to speed things up. Right now the Foxpro tables are used for everything so they have only the most necessary indexes.
В списке pgsql-novice по дате отправления: