Re: optimum postgres server configuration

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: optimum postgres server configuration
Дата
Msg-id x7d6fzby9w.fsf@yertle.int.kciLink.com
обсуждение исходный текст
Ответ на optimum postgres server configuration  (tom dyson <tom@torchbox.com>)
Ответы Re: optimum postgres server configuration  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Dmitry Tkach
Дата:
Сообщение: Re: Postgres unique index checking and atomic transactions
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: SAP DB: The unsung Open Source DB