Skip site navigation (1) Skip section navigation (2)

Re: What HW / OS is recommeded

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: What HW / OS is recommeded
Date: 2004-12-22 17:28:22
Message-ID: x7pt12fdjd.fsf@yertle.int.kciLink.com (view raw or flat)
Thread:
Lists: pgsql-general
>>>>> "a" == alex  <alex(at)meerkatsoft(dot)com> writes:


a> We are currently looking at Dell / HP
a> but the questions is

a> - how many processors (2 or 4)
a> - do we gain with 4 cpus if we probably never have a few users connected
a> - what processors are recommended  Opteron / Xeon / Itanium
a> - how much memory ?  2GB ? 4GB ?
a> - Disks, i guess we go with Raid5, 15k SCSI
a> - what OS ? Suse / RHE3 / Fedora /
a> - Disk controller ?


Run, do not walk, from your Dell solution.  I've never been able to
get "expected" performance from those boxes.  They seem to do
something to the RAID controllers to make them not work as fast as one
would expect the equivalent name-brand part (eg, LSI RAID card or
Adaptec RAID card) and similar disk drives.

Others have commented on the other aspects.  The RAID configuration is
something everyone has an opinion for.  I personally run a RAID5 on 14
disks, but the new server replacing this Dell box will have RAID10 on
6 disks for data and RAID1 on 2 disks for pg_xlog + system.  It is a
dual Opteron with 4GB RAM and an Adaptec controller.  I only run
FreeBSD.

See the performance mailing list for a big discussion on vendors just
two or three weeks ago.


-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com       Rockville, MD  +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

In response to

Responses

pgsql-general by date

Next:From: Együd Csaba (Freemail)Date: 2004-12-22 17:29:17
Subject: Re: Strange Index behavior
Previous:From: Vivek KheraDate: 2004-12-22 17:18:11
Subject: Re: increasing max_connections on freebsd

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group