Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cgK8S-0002Cl-Ht for pgsql-performance@arkaria.postgresql.org; Tue, 21 Feb 2017 23:46:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cgK8S-0004qv-4u for pgsql-performance@arkaria.postgresql.org; Tue, 21 Feb 2017 23:46:20 +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.84_2) (envelope-from ) id 1cgK8Q-0004q1-Rl for pgsql-performance@postgresql.org; Tue, 21 Feb 2017 23:46:19 +0000 Received: from mail-wm0-x22c.google.com ([2a00:1450:400c:c09::22c]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cgK8O-00068p-3W for pgsql-performance@postgresql.org; Tue, 21 Feb 2017 23:46:17 +0000 Received: by mail-wm0-x22c.google.com with SMTP id v186so126866986wmd.0 for ; Tue, 21 Feb 2017 15:46:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=0ssI1bL2V3CxpvLuxfQJnDj45hSwsq2oTWN6CamrS/k=; b=Lbdp6dpqIwg+vktA2D5UUpVBZG/Bq9F7fX1Fq1OYkIrIFSJBNjhfi5C27WFuqVKsud Tsld3KmD9Roc0/Z9RxUzKR1uJpimsTacfK0LKo9i/xnDIbBRDP20u2d9nfB4Pdxo9wfV lxnOO0mLzbyUT9oFROaEhCcJ2qjz+npcxqMfuY3mAu/V0eOSm8pAs+nyeo8yO0DdpjjN sTmWzm4BBJW0aX9VtQY2A+0WdXGY3MReTzhw7O2QO/2UHVX9jyYOKSOqVK6V1qFj8+Nu fV2ZSYFeuofUuDC8ZDs/IHeDsQwOn+4jj77iYfcAKXN7eNIOGHCP89Id3TjQNjw6prBl rAdg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=0ssI1bL2V3CxpvLuxfQJnDj45hSwsq2oTWN6CamrS/k=; b=EnG04Ll9X1udVlyfARO/9Cf909sdBQ0yX+6QGhgt0a5fJmHQ63PgXdiPaqE2uphSPo JHwxDWKbqMXcYYOqCb3/4a1Dk37ruwJUGLRb1KJ3lk23XQsEYh80ASYo10jaGfElInVQ GJZcyFU7bf9FlykO4X1VDLIFXrbXtwhMbbzTy+35ugcrHEejWrKLPlInJqYpCJN6/9vC u9/Tl4YemPu3tCuzzI0sY53YNiiSWTMpStKf+kbcVi88BTAmjYoVaH4CW1mZ5wwSiBtV x/WoRPL0USGSY/5LrX5B+w08LuzE4QSgOW0BK5rEfSC8IzxDoJW16PTkJ0G7qVFXAH2v FjIA== X-Gm-Message-State: AMke39kAcI8c1UN8TLk8ktknMbmVkXNdrHk+n7fUS4Ig9nWChZui1Y0poNmGd8h+80C/dA== X-Received: by 10.28.210.65 with SMTP id j62mr16039989wmg.9.1487720774730; Tue, 21 Feb 2017 15:46:14 -0800 (PST) Received: from [192.168.2.5] (2-230-140-245.ip202.fastwebnet.it. [2.230.140.245]) by smtp.gmail.com with ESMTPSA id j80sm19384038wmd.14.2017.02.21.15.46.13 (version=TLS1 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Tue, 21 Feb 2017 15:46:14 -0800 (PST) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\)) Subject: Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) From: Pietro Pugni In-Reply-To: Date: Wed, 22 Feb 2017 00:46:13 +0100 Cc: "pgsql-performance@postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: <861F33C2-A55C-4036-9922-C6DA258A2B7D@gmail.com> References: To: Scott Marlowe X-Mailer: Apple Mail (2.3124) X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org > Suggestion #1 is to turn off any write caching on the RAID controller. Us= ing LSI MegaRAID we went from 3k to 5k tps to 18k just turning off write ca= ching. Basically it just got in the way. Write caching is disabled because I removed the expansion card of the RAID = controller. It didn=E2=80=99t let the server boot properly with SSDs mounte= d. Thank you for the suggestion Pietro Pugni --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance