| From: | Jesper Krogh <jesper(at)krogh(dot)cc> |
|---|---|
| To: | Steven Crandell <steven(dot)crandell(at)gmail(dot)com> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: hardware upgrade, performance degrade? |
| Date: | 2013-03-02 07:30:22 |
| Message-ID: | 3651A562-DBBC-4F0F-AD59-BF03420A46B0@krogh.cc |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 01/03/2013, at 10.52, Steven Crandell <steven(dot)crandell(at)gmail(dot)com> wrote:
> Recently I moved my ~600G / ~15K TPS database from a
> 48 core(at)2(dot)0GHz server with 512GB RAM on 15K RPM disk
> to a newer server with
> 64 core(at)2(dot)2Ghz server with 1T of RAM on 15K RPM disks
>
> The move was from v9.1.4 to v9.1.8 (eventually also tested with v9.1.4 on the new hardware) and was done via base backup followed by slave promotion.
> All postgres configurations were matched exactly as were system and kernel parameters.
>
my guess is that you have gone down in clockfrequency on memory when you doubled the amount of memory
in a mainly memory cached database the performance is extremely sensitive to memory speed
Jesper
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2013-03-03 20:16:07 | Re: hardware upgrade, performance degrade? |
| Previous Message | Scott Marlowe | 2013-03-02 06:51:21 | Re: hardware upgrade, performance degrade? |