Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jW2Zd-0007t1-Mb for pgsql-hackers@arkaria.postgresql.org; Tue, 05 May 2020 18:45:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jW2Zc-0000iK-Gw for pgsql-hackers@arkaria.postgresql.org; Tue, 05 May 2020 18:45:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jW2Zc-0000iD-Ar for pgsql-hackers@lists.postgresql.org; Tue, 05 May 2020 18:45:44 +0000 Received: from mail-qv1-xf30.google.com ([2607:f8b0:4864:20::f30]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jW2ZZ-00085X-Ne for pgsql-hackers@postgresql.org; Tue, 05 May 2020 18:45:43 +0000 Received: by mail-qv1-xf30.google.com with SMTP id h6so1544423qvz.8 for ; Tue, 05 May 2020 11:45:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=nWzTlSXZ/aaCVy4Y6fXjYyDgJcxrMrDFFmRMWT53ll0=; b=uSiGWF84xoCAsI/q8DZ13BZMSA1EYomZ5+/cAjyD5CjFE3aXdW/e++R7SNkT9S4Ut8 xKKJj2x7AHEuiNFY1Dym1sFQUb1I/uHrpvKwojz41T0bzF9ElPCplC0PylH80resX/am ycDbwkLQ2R2SLiN9jj37ZCyIvimrffp4UD4ri7UZrOsIbW/v3uFqtqNlppY1uCK82eCj oqCjYgNIwCQz2Q7aJ/HOsWOcXEhyxmg8e/fgxMB/Dt1gR5tQkxp3IIbwM3ySbcogAyoi SDQZPkI3YWGhrDrvjBGImW3Toj6tUwAGZvz3sbu3Xc6I8oK7StbulNTglQ8w99+6XjgP 0TGw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=nWzTlSXZ/aaCVy4Y6fXjYyDgJcxrMrDFFmRMWT53ll0=; b=lidzsd9MfCeRtSdclvTJLMYLWLn6gUyfVIhBSmKTMbkru+q5lLvE4+Y+LHMSLR4o1g 3VJ7+Ya+5ADfDgqXPIYMja7T7F9yT6rJ106E6OWhGuWJLrnRagaho64kQld9Up3NFOEq AXGFV6BKMX1UgZQsnGkvoIUJWtYYxQi/sU6Qx4e6aLdNXbsGRPPPFAo4/CT+X/4+Rm3U 5EJqfjE1mZVuQtb4nV2olB7Q54+R8r0TNqf2HGCchXTqq458isaXLgdJyY/O0biEenkx WkOzdgVnkRrxw//TfgLVJaEApsyHzNMt7fuheS+tDytVdtYwXev0HrhmNMTcmq2YuhsE jzIA== X-Gm-Message-State: AGi0PuazukAqtYbkPsUWeOQBPGUwXrCOvCPyN+s8nEzg3g7g+aGxS0ca pIas3ITAk+o7awCi8E/qirnj2Q== X-Google-Smtp-Source: APiQypJQaNDFkYaJVqPLEJJupmeH7Cb0/niNLkXea5NrBStewpN9LYYc8mEkzbQ14kuSze74tBSTcg== X-Received: by 2002:a0c:f84b:: with SMTP id g11mr3945625qvo.155.1588704340062; Tue, 05 May 2020 11:45:40 -0700 (PDT) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id j16sm2386156qkl.118.2020.05.05.11.45.39 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 05 May 2020 11:45:39 -0700 (PDT) Received: by pryzbyj (Postfix, from userid 1000) id A5622800A79; Tue, 5 May 2020 13:45:37 -0500 (CDT) Date: Tue, 5 May 2020 13:45:37 -0500 From: Justin Pryzby To: Bruce Momjian Cc: PostgreSQL-development Subject: Re: PG 13 release notes, first draft Message-ID: <20200505184537.GC28974@telsasoft.com> References: <20200505031600.GB21752@momjian.us> <20200505164503.GY28974@telsasoft.com> <20200505171809.GF21185@momjian.us> <20200505175001.GA28974@telsasoft.com> <20200505181024.GG21185@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20200505181024.GG21185@momjian.us> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, May 05, 2020 at 02:10:24PM -0400, Bruce Momjian wrote: > > > > | This is controlled by GUC wal_skip_threshold. > > > > I think you should say that's a size threshold which determines which strategy > > > > to use (WAL or fsync). > > > > > > I went with: > > > The WAL write amount where this happens is controlled by wal_skip_threshold. > > > > > > They can use the doc link if they want more detail. > > > > I guess I would say "relations larger than wal_skip_threshold will be fsynced > > rather than copied to WAL" > > How is this? > > Relations larger than wal_skip_threshold will have their files fynsced > rather than writing their WAL records. I see I was too late, but: Fix typo (fynsc) and maybe add parens(). -- Justin