From: | "Roberto Scattini" <roberto(dot)scattini(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | server install recommendations? |
Date: | 2008-10-16 13:22:03 |
Message-ID: | d70926850810160622i72f0376axaaeef743a903b5b8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 __
((__)(('(( ((_)
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-10-16 13:31:01 | Re: Problems with Timezones in Australia |
Previous Message | Sam Mason | 2008-10-16 13:19:23 | Re: ADO TO ODBC |