Search Postgresql Archives

Re: Upgrading from 9.2 to 9.3 causes performance degradation

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

 



On 3/24/2014 7:45 AM, Álvaro Nunes Lemos Melo wrote:
- New: Xeon E5-2430 2.20GHz
- Old: Xeon X3470   2.93GHz
Memory: 8 GBs

note your OLD server was faster per gigahertz. Intel PR not withstanding, GHz remains more important for single threaded performance than about anything else. the additional features of the E5 cpu don't do that much for postgres, they are mostly of interest to video processing and such. the e5 does have larger cache, but thats not always that important. both processors have similar memory bandwidth. that E5 is a 6-core, while that x3470 is a 4-core, but that has no impact on single threaded performance, only matters if you're running enough queries concurrently to use all the cores.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[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