Help specifying new web server/database machine

Поиск
Список
Период
Сортировка
От Rory Campbell-Lange
Тема Help specifying new web server/database machine
Дата
Msg-id 20050608163418.GA3327@campbell-lange.net
обсуждение исходный текст
Ответы Re: Help specifying new web server/database machine  (Bjoern Metzdorf <bm@turtle-entertainment.de>)
Re: Help specifying new web server/database machine  (Matthew Nuzum <mattnuzum@gmail.com>)
Re: Help specifying new web server/database machine  (William Yu <wyu@talisys.com>)
Список pgsql-performance
I'm tasked with specifying a new machine to run a web application
prototype. The machine will be serving web pages with a Postgresql
backend; we will be making extensive use of plpgsql functions. No
database tables are likely to go over a million rows during the
prototype period.

We are considering two RAID1 system disks, and two RAID1 data disks.
We've avoided buying Xeons. The machine we are looking at looks like
this:

    Rackmount Chassis - 500W PSU / 4 x SATA Disk Drive Bays
    S2882-D - Dual Opteron / AMD 8111 Chipset / 5 x PCI Slots
    2x - (Dual) AMD Opteron 246 Processors (2.0GHz) - 1MB L2 Cache/core (single core)
    2GB (2x 1024MB) DDR-400 (PC3200) ECC Registered SDRAM (single rank)
    4 Port AMCC/3Ware 9500-4LP PCI SATA RAID Controller
    80GB SATA-150 7200RPM Hard Disk / 8MB Cache
    80GB SATA-150 7200RPM Hard Disk / 8MB Cache
    250GB SATA-150 7200RPM Hard Disk / 8MB Cache
    250GB SATA-150 7200RPM Hard Disk / 8MB Cache
    Slimline 8x DVD / 24x CD-ROM Drive
    Standard 3yr (UK) Next Business Day On-site Warranty

I would be grateful for any comments about this config.

Kind regards,
Rory
--
Rory Campbell-Lange
<rory@campbell-lange.net>
<www.campbell-lange.net>

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: full outer performance problem
Следующее
От: Bjoern Metzdorf
Дата:
Сообщение: Re: Help specifying new web server/database machine