Postgres Pro
Downloads
Home   >   mailing lists

Re: which hardware setup - Mailing list pgsql-performance

From Jesper Krogh
Subject Re: which hardware setup
Date
Msg-id AA6446E0-74B2-4977-826F-FD5185AA24A0@krogh.cc
Whole thread Raw
In response to which hardware setup  (Pedro Axelrud <pedroaxl@gmail.com>)
Responses Re: which hardware setup  (Pedro Axelrud <pedroaxl@gmail.com>)
List pgsql-performance
Tree view 
> 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: Łukasz Dejneka
Date:
Subject: Certain query eating up all free memory (out of memory error)
Next
From: Łukasz Dejneka
Date:
Subject: Re: Certain query eating up all free memory (out of memory error)