Date: Tue, 10 Apr 2018 09:21:53 +0200 (CEST)
From: Andreas Joseph Krogh <andreas@visena.com>
To: pgsql-performance@lists.postgresql.org
Message-ID: <VisenaEmail.c.d0d82e38c7187473.162ae6e010b@tc7-visena>
In-Reply-To: 
 <CAFwQ8rcCSiD2jC1JXHEh4fjxjzP+M9gGnbBNHj_+rm=Ng2ea+A@mail.gmail.com>
Subject: Sv: Latest advice on SSD?
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_Part_55_1493850074.1523344913300"
Precedence: bulk

------=_Part_55_1493850074.1523344913300
Content-Type: multipart/related;
	boundary="----=_Part_56_1483532766.1523344913300"

------=_Part_56_1483532766.1523344913300
Content-Type: multipart/alternative;
	boundary="----=_Part_57_1002588719.1523344913310"

------=_Part_57_1002588719.1523344913310
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

P=C3=A5 tirsdag 10. april 2018 kl. 04:36:27, skrev Craig James <cjames@emol=
ecules.com
 <mailto:cjames@emolecules.com>>:
One of our four "big iron" (spinning disks) servers went belly up today.=20
(Thanks, Postgres and pgbackrest! Easy recovery.) We're planning to move to=
 a=20
cloud service at the end of the year, so bad timing on this. We didn't want=
 to=20
buy any more hardware, but now it looks like we have to.=C2=A0
I followed the discussions about SSD drives when they were first becoming=
=20
mainstream; at that time, the Intel devices were king. Can anyone recommend=
=20
what's a good SSD configuration these days? I don't think we want to buy a =
new=20
server with spinning disks.
=C2=A0
We're replacing:
=C2=A0 8 core (Intel)
=C2=A0 48GB memory
 =C2=A0 12-drive 7200 RPM 500GB
=C2=A0 =C2=A0 =C2=A0RAID1 (2 disks, OS and WAL log)
=C2=A0 =C2=A0 =C2=A0RAID10 (8 disks, postgres data dir)
=C2=A0 =C2=A0 =C2=A02 spares
=C2=A0 Ubuntu 16.04
=C2=A0 Postgres 9.6
=C2=A0
The current system peaks at about 7000 TPS from pgbench.

=C2=A0
With what arguments (also initialization)?
=C2=A0
--
Andreas Joseph Krogh

=C2=A0

------=_Part_57_1002588719.1523344913310
Content-Type: text/html;charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>P=C3=A5 tirsdag 10. april 2018 kl. 04:36:27, skrev Craig James &lt;<a =
href=3D"mailto:cjames@emolecules.com">cjames@emolecules.com</a>&gt;:</div>

<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir=3D"ltr">One of our four &quot;big iron&quot; (spinning disks) serv=
ers 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 ti=
ming on this. We didn't want to buy any more hardware, but now it looks lik=
e we have to.
<div>=C2=A0</div>

<div>I followed the discussions about SSD drives when they were first becom=
ing mainstream; at that time, the Intel devices were king. Can anyone recom=
mend what's a good SSD configuration these days? I don't think we want to b=
uy a new server with spinning disks.</div>

<div>=C2=A0</div>

<div>We're replacing:</div>

<div>=C2=A0 8 core (Intel)</div>

<div>
<div style=3D"color:rgb(34,34,34);font-family:arial,sans-serif;font-size:sm=
all;font-style:normal;font-variant-ligatures:normal;font-variant-caps:norma=
l;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;te=
xt-transform:none;white-space:normal;word-spacing:0px;text-decoration-style=
:initial;text-decoration-color:initial">=C2=A0 48GB memory</div>
=C2=A0 12-drive 7200 RPM 500GB</div>

<div>=C2=A0 =C2=A0 =C2=A0RAID1 (2 disks, OS and WAL log)</div>

<div>=C2=A0 =C2=A0 =C2=A0RAID10 (8 disks, postgres data dir)</div>

<div>=C2=A0 =C2=A0 =C2=A02 spares</div>

<div>=C2=A0 Ubuntu 16.04</div>

<div>=C2=A0 Postgres 9.6</div>

<div>=C2=A0</div>

<div>The current system peaks at about 7000 TPS from pgbench.</div>
</div>
</blockquote>

<div>=C2=A0</div>

<div>With what arguments (also initialization)?</div>

<div>=C2=A0</div>

<div class=3D"visena-email-signature" data-visena-message-id=3D"&lt;VisenaE=
mail.c.d0d82e38c7187473.162ae6e010b@tc7-visena>">
<div>--</div>

<div>Andreas Joseph Krogh</div>
</div>

<div>=C2=A0</div>
------=_Part_57_1002588719.1523344913310--

------=_Part_56_1483532766.1523344913300--

------=_Part_55_1493850074.1523344913300--