How to make a REALLY FAST db server?

Поиск
Список
Период
Сортировка
От bpalmer
Тема How to make a REALLY FAST db server?
Дата
Msg-id Pine.BSO.4.33.0109101445080.18431-100000@mizer.crimelabs.net
обсуждение исходный текст
Ответы Re: How to make a REALLY FAST db server?
Re: How to make a REALLY FAST db server?
Re: How to make a REALLY FAST db server?
Список pgsql-general
I'm looking to make a DB server for a project I'm working on (using pgsql)
and am wondering if people have suggestions?

Thoughts:

- Hardware:  dual / quad Intel class
- OS:  Prolly FreeBSD (FFS is your friend (what with syncs and all) and it
can do multi proc support
- Disk:  SCSI Raid 1+0
- Ram:  Not really sure here.  Is there math somewhere for ram needs for
pgsql? I imagine is has something to do with # connections,  db size,
etc.

Any people have any comments?

- Brandon


----------------------------------------------------------------------------
 b. palmer,  bpalmer@crimelabs.net            pgp:crimelabs.net/bpalmer.pgp5


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Supporting PostgreSQL infrastructure
Следующее
От: "Jeff Eckermann"
Дата:
Сообщение: Re: SQL Loader?