Postgres Pro
Downloads
Home   >   mailing lists

Re: which hardware setup - Mailing list pgsql-performance

From Pedro Axelrud
Subject Re: which hardware setup
Date
Msg-id AANLkTinr32Nl50BBAVd8NlYU7tzQoMQfUWBtwHhSDeYj@mail.gmail.com
Whole thread Raw
In response to Re: which hardware setup  (Jesper Krogh <jesper@krogh.cc>)
List pgsql-performance
Tree view
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 by date:

Previous
From: "Jorge Montero"
Date:
Subject: Re: Query timing increased from 3s to 55s when used as a function instead of select
Next
From: Scott Carey
Date:
Subject: Re: prepared query performs much worse than regular query