| From: | Walter Vaughan <wvaughan(at)steelerubber(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Hardware |
| Date: | 2007-02-06 15:59:21 |
| Message-ID: | 45C8A5D9.5000206@steelerubber.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I need to purchase a new server to put posgresql on that will be acting as the
DBMS server for Apache ofBiz soon. While googling around for performance tweaks
I saw this at http://revsys.com/writings/postgresql-performance.html
<quote>
CPUs — The more CPUs the better, however if your database does not use many
complex functions your money is best spent on a better disk subsystem. Also,
avoid Intel Xeon processors with PostgreSQL as there is a problem with the
context switching in these processors that gives sub-par performance. Opterons
are generally accepted as being a superior CPU for PostgreSQL databases.
</quote>
Is this still true in regards to Xeon's? I was looking at a server with Quad
Core Xeon 2 5335 @ 2.0GHz.
And at http://www.powerpostgresql.com/PerfList
<quote>
focus on RAID 1 or 1+0 or 0+1 for any set of 2, 4 or 6 disks.
</quote>
Are RAID 1 or 1+0 or 0+1 equal in speed, performance, downtime in regards to
postgresql. Is it a coin toss?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Peterson | 2007-02-06 16:01:33 | Re: create operator class problem |
| Previous Message | Andrew Sullivan | 2007-02-06 15:54:33 | Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade |