On Tue, Apr 10, 2018 at 12:21 AM, Andreas Joseph Krogh <andreas@xxxxxxxxxx> wrote:
På tirsdag 10. april 2018 kl. 04:36:27, skrev Craig James <cjames@xxxxxxxxxxxxxx>:One of our four "big iron" (spinning disks) servers went belly up today. (Thanks, Postgres and pgbackrest! Easy recovery.) We're planning to move to a cloud service at the end of the year, so bad timing on this. We didn't want to buy any more hardware, but now it looks like we have to.I followed the discussions about SSD drives when they were first becoming mainstream; at that time, the Intel devices were king. Can anyone recommend what's a good SSD configuration these days? I don't think we want to buy a new server with spinning disks.We're replacing:8 core (Intel)48GB memory12-drive 7200 RPM 500GBRAID1 (2 disks, OS and WAL log)RAID10 (8 disks, postgres data dir)2 sparesUbuntu 16.04Postgres 9.6The current system peaks at about 7000 TPS from pgbench.With what arguments (also initialization)?
pgbench -i -s 100 -U test
pgbench -U test -c ... -t ...
-c -t TPS
5 20000 5202
10 10000 7916
20 5000 7924
30 3333 7270
40 2500 5020
50 2000 6417
--Andreas Joseph Krogh
---------------------------------
Craig A. James
Chief Technology OfficerCraig A. James
