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 1jWDiH-0002YG-Vn for pgsql-hackers@arkaria.postgresql.org; Wed, 06 May 2020 06:39:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jWDiG-0002G0-Af for pgsql-hackers@arkaria.postgresql.org; Wed, 06 May 2020 06:39:24 +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 1jWDiF-0002Ft-S4 for pgsql-hackers@lists.postgresql.org; Wed, 06 May 2020 06:39:24 +0000 Received: from mail-pf1-x442.google.com ([2607:f8b0:4864:20::442]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jWDi8-0000De-Gi for pgsql-hackers@postgresql.org; Wed, 06 May 2020 06:39:23 +0000 Received: by mail-pf1-x442.google.com with SMTP id w65so499034pfc.12 for ; Tue, 05 May 2020 23:39:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=cv1JfxBe+FTfes3VXCvneLTHsAKJdR/U+IzMc7AntTA=; b=cY6x3puX1PsJUzgSMKLUASXYokd3tuBdNGt7WeNci+l33viyhvQV5Qm84EdX867BMs 1W6F81trk42l47oqadfcw10YM6HM7oaj90ebb3g3HbKQ9Kd7Lweq+JNFKSbONXFHPv/z eJ0BIpGq+Bdn/FqKu6hnjqhSCScxOxzXop0PE= 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=cv1JfxBe+FTfes3VXCvneLTHsAKJdR/U+IzMc7AntTA=; b=tJHlNJOoPsgvMyMFuQd/30xnuS5x0aIZFo0dVq4DVI7k2sEkpq+sMUPCRLFff2WluF 7itacKWWLyd9aa99HfN87hy3hB9C9VqUH1VNqrisb5F9NGWnht4VwE8QYb7OkeylRbnd b5M2iAwT7tsGWo8V3JcNBiLzdXXhz14e5M3ZE054OBHvNvoZ3/Z1TCOZvxiWxqO6RKUE /7u1lmwCwztVkW+KoKsA7cEkLCc7nfE5eoE97Y1flvi45TnjEMoYe6mwo8NyrOITNVuT bJqZ0+mHLv5wbLwSRRDNK5RFK7tPYSPt9uDN7Zk5vCpcOeJsNmexH80JEnu0ynZTIG5Z qbsA== X-Gm-Message-State: AGi0PuZViRmQkv85BXYT5peDnAEiekpLlKSzRn7rAz1/J24Ug7YxZ2ee t2hVmKBu/oLMWqOEe8cFenR6aw== X-Google-Smtp-Source: APiQypKfd40l6hwGB2mDayep4XDlT956fRrbRO7KEK95cn+YzZYOH39Rul07Sl5c9ZyVNa3KZLI3Cw== X-Received: by 2002:a63:ce53:: with SMTP id r19mr5620033pgi.395.1588747153480; Tue, 05 May 2020 23:39:13 -0700 (PDT) Received: from rfd.leadboat.com (108-233-125-46.lightspeed.sntcca.sbcglobal.net. [108.233.125.46]) by smtp.gmail.com with ESMTPSA id u3sm785309pfn.217.2020.05.05.23.39.12 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 05 May 2020 23:39:12 -0700 (PDT) Date: Tue, 5 May 2020 23:39:10 -0700 From: Noah Misch To: Bruce Momjian Cc: PostgreSQL-development Subject: Re: PG 13 release notes, first draft Message-ID: <20200506063910.GA515983@rfd.leadboat.com> References: <20200505031600.GB21752@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20200505031600.GB21752@momjian.us> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Mon, May 04, 2020 at 11:16:00PM -0400, Bruce Momjian wrote: > Allow skipping of WAL for new tables and indexes if wal_level is 'minimal' (Noah Misch) Kyotaro Horiguchi authored that one. (I committed it.) The commit message noted characteristics, some of which may deserve mention in the notes: - Crash recovery was losing tuples written via COPY TO. This fixes the bug. - Out-of-tree table access methods will require changes. - Users setting a timeout on COMMIT may need to adjust that timeout, and log_min_duration_statement analysis will reflect time consumption moving to COMMIT from commands like COPY. - COPY has worked this way for awhile; this extends it to all modifications.