Search Postgresql Archives

Re: PostgreSQL on Dual Processors, Dual-Core AMD Chips

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Onyx wrote:
Hello Everyone,
Does anyone know if PostgreSQL supports running on dual processors, and will efficiently utilize the dual processors for performance? More specifically, will PostgreSQL utilize the dual processor performance of using dual-core AMD chips? Any information would be helpful...

We've got a 2x265 production server that runs like gangbusters. This was a CPU drop-in replacement upgrade so we were able to do some simple testing of 1x265 versus 2x244 (both setups w/ 2 1.8GHz cores). The 1x265 was faster in pretty much everything we threw at it by 10%-15%. I suspect the performance difference of a 2x265 versus a 4x844 would be even greater due to the big latency hit in a 4 socket Opteron system.

Expect to need to upgrade to later Linux cores though. Previous kernel on this server was 2.6.9+ (FC3 64-bit) -- promptly kernel panic'd upon install of the DCs. FC3 installer did the same thing. Went to FC4 (2.6.11+) and it has run perfect for the past 3 months. We'll probably do a yum update to 2.6.13+ to take advantage of the better NUMA code now that we've successfully done this update on a less critical server.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux