Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d3nGl-0001OV-Jh for pgsql-performance@arkaria.postgresql.org; Thu, 27 Apr 2017 17:31:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d3nGk-00070d-JT for pgsql-performance@arkaria.postgresql.org; Thu, 27 Apr 2017 17:31:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d3nEv-0000oB-Kv; Thu, 27 Apr 2017 17:30:01 +0000 Received: from lists.commandprompt.com ([2604:da00:2:2:5054:ff:fe07:7618]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d3nEm-0003sR-At; Thu, 27 Apr 2017 17:30:00 +0000 Received: from [192.168.1.50] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 341ABEF; Thu, 27 Apr 2017 10:29:49 -0700 (PDT) Received: from c-73-225-27-179.hsd1.wa.comcast.net ([73.225.27.179] helo=[192.168.1.50]) by assp.commandprompt.com with SMTPSA(TLSv1_2 ECDHE-RSA-AES128-GCM-SHA256) (2.5.1); 27 Apr 2017 10:29:48 -0700 Subject: Re: Questionaire: Common WAL write rates on busy servers. To: Andres Freund References: <20170425041743.ddabv2mwevcmtx5a@alap3.anarazel.de> <20170427155906.uudovtd62x56brmx@alap3.anarazel.de> <20170427163407.dtqi6v57bj4tiu5c@alap3.anarazel.de> Cc: pgsql-general@postgresql.org, pgsql-performance@postgresql.org From: "Joshua D. Drake" Organization: Command Prompt, Inc. Message-ID: <80f280c1-910f-7eae-33a2-fd0cfc9ee8c9@commandprompt.com> Date: Thu, 27 Apr 2017 10:29:48 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.8.0 MIME-Version: 1.0 In-Reply-To: <20170427163407.dtqi6v57bj4tiu5c@alap3.anarazel.de> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.5.1(16177) on assp.commandprompt.com X-Assp-ID: assp.commandprompt.com m1-14189-10860 X-Assp-Session: 7FF93CF1FB28 (mail 1) X-Assp-Original-Subject: Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. X-Assp-Client-SSL: yes X-Pg-Spam-Score: -1.9 (-) 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 On 04/27/2017 09:34 AM, Andres Freund wrote: > On 2017-04-27 09:31:34 -0700, Joshua D. Drake wrote: >> On 04/27/2017 08:59 AM, Andres Freund wrote: >> >> I would agree it isn't yet a widespread issue. > > I'm not yet sure about that actually. I suspect a large percentage of > people with such workloads aren't lingering lots on the lists. That would probably be true. I was thinking of it more as the "most new users are in the cloud" and the "cloud" is going to be rare that a cloud user is going to be able to hit that level of writes. (at least not without spending LOTS of money) > > >> The only people that are likely going to see this are going to be on bare >> metal. We should definitely plan on that issue for say 11. > > "plan on that issue" - heh. We're talking about major engineering > projects here ;) Sorry, wasn't trying to make light of the effort. :D > > >> I do have a question though, where you have seen this issue is it with >> synchronous_commit on or off? > > Both. Whether that matters or not really depends on the workload. If you > have bulk writes, it doesn't really matter much. Sure, o.k. Thanks, Andres > > - Andres > -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. Unless otherwise stated, opinions are my own. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance