Re: Server upgrade advice - Mailing list pgsql-general

From Kenneth Marshall
Subject Re: Server upgrade advice
Date
Msg-id 20190305202913.GB15586@aart.rice.edu
Whole thread Raw
In response to Server upgrade advice  (Rory Campbell-Lange <rory@campbell-lange.net>)
Responses Re: Server upgrade advice  (Rory Campbell-Lange <rory@campbell-lange.net>)
List pgsql-general
> 
> Consequently we're thinking of the following replacement servers:
> 
>     postgres 11 (planned)
>     supermicro 113TQ-R700W 
>     LSI MegaRAID 9271-8i SAS/SATA RAID Controller, 1Gb DDR3 Cache (PCIE- Gen 3)
>         500gb raid 1 /
>         2tb raid 10 /db
>         with "zero maintenance flash cache protection"
>     256GB RAM (2666MHz DDR4)
>     2x E5-2680 v4 Intel Xeon, 14 Cores, 2.40GHz, 35M Cache,
> 
> This configuration gives us lots more storage, double the RAM (with 8
> slots free) and just under 4x CPU (according to passmark) with lots more
> cores.
> 
> We're hoping to get two to three years of service out of this upgrade,
> but then will split the cluster between servers if demand grows more
> than we anticipate.
> 
> Any comments on this upgrade, strategy or the "zero maintenance" thingy
> (instead of a BBU) would be much appreciated.
> 
> Rory
> 

Hi Rory,

Is there a reason not to consider an all flash solution? The AMD EPYC
processor series supports enough NVMe channels to support your sizing.
The 7401P single processor is a good value proposition.

Regards,
Ken


pgsql-general by date:

Previous
From: Boris Sagadin
Date:
Subject: Re: Slave server sometimes locks up
Next
From: Rory Campbell-Lange
Date:
Subject: Re: Server upgrade advice