[PERFORM] New server optimization advice

2015-01-09 Thread Steve Crawford
I will soon be migrating to some recently acquired hardware and seek input from those who have gone before. A quick overview: the dataset size is ~100GB, (~250-million tuples) with a workload that consists of about 2/3 writes, mostly single record inserts into various indexed tables, and 1/3 r

Re: [PERFORM] New server optimization advice

2015-01-09 Thread Claudio Freire
On Fri, Jan 9, 2015 at 4:26 PM, Steve Crawford wrote: > New hardware is quite different. 2x10-core E5-2660v3 @2.6GHz, 128GB > DDR4-2133 RAM and 800GB Intel DC P3700 NVMe PCIe SSD. In essence, the > dataset will fit in RAM and will be backed by exceedingly fast storage. > > This new machine is very