server install recommendations?
От | Roberto Scattini |
---|---|
Тема | server install recommendations? |
Дата | |
Msg-id | d70926850810160622i72f0376axaaeef743a903b5b8@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: server install recommendations?
Re: server install recommendations? Re: server install recommendations? |
Список | pgsql-general |
hi everybody: in a couple of days i will reinstall an offline database server. It's a old HP Proliant DL580 G3 with three disks (147 GB each). Currently it has a debian Sarge in a RAID5 hardware array ( with HP Smart Array 6i, [RAID bus controller: Compaq Computer Corporation Smart Array 64xx (rev 01)] ). i googled a while and get to this page: http://www.powerpostgresql.com/PerfList , so my first question is, this document and the tips given hasn't been deprecated by now, right? then: -is raid5 the worst election in this scenario (three disks)? -which is the best (and with that i mean secure in first place and with more perfomance in second) possible configuration achievable with this three disks? -should i ask my boss to buy another disk? (it will be difficult, but if i can demonstrate It worth it...) i think i will "Separate the Transaction Log from the Database" with two RAID1 arrays (if they buy the new disk). is this a good way to go? it would be too bad if i put the logs in a disk without RAID? (only if i dont get the new disk...) our application (running on separate webserver) is of the type "OLTP", the server will be entirely dedicated to postgresql. i will configure a warm-standby server, so the WAL files will be forwarded to another server. thanks in advance! -- Roberto Scattini ___ _ ))_) __ )L __ ((__)(('(( ((_)
В списке pgsql-general по дате отправления: