Re: optimum postgres server configuration - Mailing list pgsql-general

From Vivek Khera
Subject Re: optimum postgres server configuration
Date
Msg-id x7d6fzby9w.fsf@yertle.int.kciLink.com
Whole thread Raw
In response to optimum postgres server configuration  (tom dyson <tom@torchbox.com>)
Responses Re: optimum postgres server configuration  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
>>>>> "td" == tom dyson <tom@torchbox.com> writes:

td> and software, given a smallish fixed budget (around $US 2000)? In
td> particular, should we prioritise

td> * Disk speed
td> * Hardware RAID
td> * Memory
td> * Processor speed
td> * Processor type
td> * Multiple processors

Like others have said, splurge on the disk speed.  Personally I use
hardware RAID 10, but I'm not on a tight budget.  Any modern system
will have enough CPU power.  Next thing to maximize is RAM.

Another thing to consider is leasing the equipment.  Instead of
putting up the $2k cash now, spread out the money outlay over three
years.  You can buy a much bigger machine with lower cash flow impact.


--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

pgsql-general by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: Postgres unique index checking and atomic transactions
Next
From: "scott.marlowe"
Date:
Subject: Re: SAP DB: The unsung Open Source DB