Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fH9LX-0004l1-HH for pgsql-performance@arkaria.postgresql.org; Fri, 11 May 2018 14:48:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fH9LW-00088V-A0 for pgsql-performance@arkaria.postgresql.org; Fri, 11 May 2018 14:48:34 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fH9LV-00087W-TO for pgsql-performance@lists.postgresql.org; Fri, 11 May 2018 14:48:34 +0000 Received: from mail-lf0-x22d.google.com ([2a00:1450:4010:c07::22d]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fH9LS-0000WT-5G for pgsql-performance@lists.postgresql.org; Fri, 11 May 2018 14:48:32 +0000 Received: by mail-lf0-x22d.google.com with SMTP id y72-v6so8312962lfd.2 for ; Fri, 11 May 2018 07:48:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:message-id:mime-version:subject:date:in-reply-to:cc:to :references; bh=v0iObiDBCIsUURwrjJLrAwOALELdguCKIz+zVRhoHQE=; b=jD4faBrH7KrEYUzWnNSVXGF9+BQTOgqwOhL19phpqWcZ/xpGIIHVH5gyXwDNC8LRVX N9e17TnKPADSjc4f/aITUP9zg0BeZMjGhnOoaMMhHUYlJydVyOT+vmErUZzvVlimMiIY RjErbplrgAJYozk9MnKWYaNWXwGPwQkTcFtieNV2D30wc5Kww6qLQwCFCx6N1/khH3xq uwSZ7CSGhdDWFo726mP8KhLWmeCkM+xoxK2zKwlt0S8/ihwJWnTgO0tHQmAbt6qtxU5N XDnvj9iEfslGgn1CnMxcgib7Wk7kQo0wJrLIOVpUin9Uq+YWda6abM/6UlsqkqG6IN6M jg6A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:message-id:mime-version:subject:date :in-reply-to:cc:to:references; bh=v0iObiDBCIsUURwrjJLrAwOALELdguCKIz+zVRhoHQE=; b=Yl5MLG9/+pP3rlUlzHl/1zdUnaqyUIkXeYRLmCdqqJtI3aak9IHxollnqZB9Qc0DfV thkZm8UXPWBYO7gu/aw/Lk7eJ/aES0cHj5Gg72UtMGn5FZnGMkQA6D4IUqBvyBIysP3b KgEafJQp2oAycPeC2taSvxdwGdj8cZDnPcxZNznLYpw3kCsIoUtvn0C7Kf/hAdHuIiAo M3ilkVzDWiG2ZrM+EmPnCeFuFLZPjz3ve9qktqQOQLwGoKP0zxxC6c8gZpmNTfxfYtaP KAQP9MH7Ns6COYfupSQM2pY3yIv8bvDkR4TDplcydx0TAOxsjZJMTWTFI9vfXqGFGL6z NLTA== X-Gm-Message-State: ALKqPwfK9h8+hacb6kaieii8rQhF1F8GDwHkodvUc3UZFT8gyXBywlt1 6MnufM153dmX27BqKiBlkUunMhvV X-Google-Smtp-Source: AB8JxZrolbqNXqu2RrZaylka2tFRFRuBJ9Xt49WAfGZMH4yuR9K7QFeKTkErXBiZTTqlPkxqh+pgzw== X-Received: by 2002:a2e:90d4:: with SMTP id o20-v6mr4272882ljg.15.1526050108125; Fri, 11 May 2018 07:48:28 -0700 (PDT) Received: from [192.168.1.235] ([178.121.221.91]) by smtp.gmail.com with ESMTPSA id u2-v6sm685267lfu.3.2018.05.11.07.48.26 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 11 May 2018 07:48:27 -0700 (PDT) From: Evgeniy Shishkin Message-Id: <9229B816-42C6-4AD0-B0E4-756C9894F52C@gmail.com> Content-Type: multipart/alternative; boundary="Apple-Mail=_D86FE278-39BD-4607-A4EE-D197B0CDA6BB" Mime-Version: 1.0 (Mac OS X Mail 11.4 \(3445.8.2\)) Subject: Re: Latest advice on SSD? Date: Fri, 11 May 2018 17:48:25 +0300 In-Reply-To: Cc: pgsql-performance@lists.postgresql.org To: Mark Kirkwood References: X-Mailer: Apple Mail (2.3445.8.2) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_D86FE278-39BD-4607-A4EE-D197B0CDA6BB Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 > On May 11, 2018, at 15:11, Mark Kirkwood = wrote: >=20 > On 11/05/18 23:23, Andreas Joseph Krogh wrote: >=20 >> P=C3=A5 onsdag 09. mai 2018 kl. 22:00:16, skrev Andreas Joseph Krogh = >: >>=20 >> FWIW; We're testing >> this: = https://www.supermicro.nl/products/system/1U/1029/SYS-1029U-TN10RT.cfm >> with 4 x Micron NVMe 9200 PRO NVMe 3.84TB U.2 in RAID-10: >> =20 > These Micron disks look interesting (pretty good IOPS and lifetime = numbers). However (as usual with Micron, sadly) no data about power off = safety. Do you know if the the circuit board has capacitors? According to = https://www.micron.com/~/media/documents/products/data-sheet/ssd/9200_u_2_= pcie_ssd.pdf = The SSD supports an unexpected power loss with a power-backed write = cache. No userdata is lost during an unexpected power loss. When power = is subsequently restored, theSSD returns to a ready state within a = maximum of 60 seconds.= --Apple-Mail=_D86FE278-39BD-4607-A4EE-D197B0CDA6BB Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8

On May 11, 2018, at 15:11, Mark Kirkwood <mark.kirkwood@catalyst.net.nz> wrote:

On = 11/05/18 23:23, Andreas Joseph Krogh wrote:

P=C3=A5 onsdag 09. mai = 2018 kl. 22:00:16, skrev Andreas Joseph Krogh <andreas@visena.com = <mailto:andreas@visena.com>>:

   FWIW; We're testing
=    this: https://www.supermicro.nl/products/system/1U/1029/SYS-1029U-TN1= 0RT.cfm
   with 4 x Micron NVMe = 9200 PRO NVMe 3.84TB U.2 in RAID-10:
  =  
These Micron disks look interesting (pretty good IOPS = and lifetime numbers). However (as usual with Micron, sadly) no data = about power off safety. Do you know if the the circuit board has = capacitors?

According to https://www.micron.com/~/media/documents/products/data-sheet/ss= d/9200_u_2_pcie_ssd.pdf

The SSD supports an unexpected power loss with a = power-backed write cache. No userdata is lost during an unexpected power = loss. When power is subsequently restored, theSSD returns to a ready = state within a maximum of 60 seconds.= --Apple-Mail=_D86FE278-39BD-4607-A4EE-D197B0CDA6BB--