| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Upgrading from 9.2 to 9.3 causes performance degradation |
| Date: | 2014-03-25 06:39:11 |
| Message-ID: | 5331248F.9050205@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johann Spies | 2014-03-25 07:47:34 | Strange result for full text query |
| Previous Message | Jeff Janes | 2014-03-25 06:05:15 | Upgrading from 9.2 to 9.3 causes performance degradation |