iGen with PostgreSQL 8.4 on Sun Fire X4140

Recently I got access to the refreshed Sun Fire X4140 consisting of 2 x 6-core Opterons with 36GB RAM. Since the release of the final PostgreSQL 8.4 bits I had not tried it out so I downloaded the Solaris 10 binaries of PostgreSQL 8.4 (64-bits) from the download site of postgresql.org and took it for the test drive with the same iGen benchmarks that I had used earlier for my PGCon2009 presentation.

The system already had Solaris 10 5/09 installed with couple of  SSDs  and a RAID LUN for the database. I put the WAL log on an internal drive with ZFS intent log on SSDs and the tablespaces on the RAID LUN (on an external storage array).

Notice the crossing of the 400K tpm boundary with PostgreSQL here using this benchmark toolkit. None of my tests have ever done that before. I consider this to be a milestone achievement with PostgreSQL, Solaris 10, Sun Fire Systems with Opterons.




Comments:

A few ?s:

1) how did you configure the ssd drives? are they utilzing raid?
2) The internal drives, do they use hardware raid or zfs raid? which do you recomend for postgres?
3) Is there anyway to repeat this test on the x4570 or x4575 with intel processors? I am curious how the performance for a fewer number of clients would be impacted by the higher clock speed and non-threaded'ness of postgres. Most of we apps utilize a connection pool with lower number of overall connections.

Thanks.

Posted by James on July 23, 2009 at 06:53 AM EDT #

Interesting, and cool.

One question: if you were to do this same test with OpenSolaris instead of Solaris 10, would it be faster or slower?

Posted by George Drapeau on July 24, 2009 at 10:47 AM EDT #

Post a Comment:
Comments are closed for this entry.
About

Jignesh Shah is Principal Software Engineer in Application Integration Engineering, Oracle Corporation. AIE enables integration of ISV products including Oracle with Unified Storage Systems. You can also follow me on my blog http://jkshah.blogspot.com

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today