Re: which hardware setup

Поиск
Список
Период
Сортировка
От Pedro Axelrud
Тема Re: which hardware setup
Дата
Msg-id AANLkTinr32Nl50BBAVd8NlYU7tzQoMQfUWBtwHhSDeYj@mail.gmail.com
обсуждение исходный текст
Ответ на Re: which hardware setup  (Jesper Krogh <jesper@krogh.cc>)
Список pgsql-performance
Дерево обсуждения
Sorry Jesper, I thought I had mentioned.. our dataset have 18GB.


Pedro Axelrud
http://mailee.me
http://softa.com.br
http://flavors.me/pedroaxl


On Tue, May 25, 2010 at 03:21, Jesper Krogh <jesper@krogh.cc> wrote:
Option 2:
App Server and Postgres: Dual Xeon 5520 quad core with 12GB ram and 2x 146GB 15k RPM SAS (RAID1) disks


 you didnt mention your dataset size, but i the second option would be preferrable in most situations since it gives more of the os memory for disc caching. 12 gb vs 4 gb for the host running pg

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

Предыдущее
От: "Jorge Montero"
Дата:
Сообщение: Re: Query timing increased from 3s to 55s when used as a function instead of select
Следующее
От: Scott Carey
Дата:
Сообщение: Re: prepared query performs much worse than regular query