server install recommendations?

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 __
((__)(('(( ((_)

Responses

Browse pgsql-general by date

  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