Re: Hardware recommendation: which is best
От | Franz.Rasper@izb.de |
---|---|
Тема | Re: Hardware recommendation: which is best |
Дата | |
Msg-id | 11EC9A592C31034C88965C87AF18C2A702B8369D@m0000s61 обсуждение исходный текст |
Ответ на | Hardware recommendation: which is best ("Phoenix Kiula" <phoenix.kiula@gmail.com>) |
Ответы |
Re: Hardware recommendation: which is best
|
Список | pgsql-general |
It depends what you want to do with your database. Do you have many reads (select) or a lot of writes (update,insert) ? You should use a hardware raid controller with battery backup write cache (write cache should be greater than 256 MB). .. heavy duty production server ? How much memory do you have ? How big is your database, tables ... ? Greetings, -Franz -----Ursprüngliche Nachricht----- Von: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] Im Auftrag von Phoenix Kiula Gesendet: Dienstag, 11. September 2007 13:49 An: Postgres General Betreff: [GENERAL] Hardware recommendation: which is best Hello We're trying to look for the most optimal config for a heavy duty production server, and the following two are falling in the same price range from our supplier: Option 1: 2 x 300GB SCSI (10k rpm) with SAS and RAID 1 Option 2: 4 x 300GB SATA2 (7200 rpm, server grade) with RAID 10 I am not sure how the pricing comes so similar with such different RAID options, but given the two above I think the second option will be better for a high volume server where Postgres is the main application? The only reason I ask is because of so many websites, and threads on this list, that trump the advantages of SCSI. Many thanks for any advice! ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
В списке pgsql-general по дате отправления: