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 1lgad9-00083g-HU for pgsql-hackers@arkaria.postgresql.org; Tue, 11 May 2021 22:13:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lgad8-0001ao-GE for pgsql-hackers@arkaria.postgresql.org; Tue, 11 May 2021 22:13:30 +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 1lgad8-0001ad-4M for pgsql-hackers@lists.postgresql.org; Tue, 11 May 2021 22:13:30 +0000 Received: from mail-ot1-x330.google.com ([2607:f8b0:4864:20::330]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lgad3-00013n-Jw for pgsql-hackers@postgresql.org; Tue, 11 May 2021 22:13:29 +0000 Received: by mail-ot1-x330.google.com with SMTP id d25-20020a0568300459b02902f886f7dd43so5439709otc.6 for ; Tue, 11 May 2021 15:13:25 -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:content-transfer-encoding:in-reply-to :user-agent; bh=zGvuzlOUxTvQexb71qY5lh6nm7NdtrSLp8MDUk6D8V8=; b=2JfxLgazvreiYZ+FGxK2pJh4PJrFCbmSsk5C+7+1ApvcJULjPaEfdikxGK2WotwLpQ GwHk4exeYuWBZWYaTPOl5Q2VIH5RtqLSIjxT+pSQgE6BbpmMmaud5qI5FP08hzxCjL0t iQYyJtNJyJj081XEkKlsDtg8eZHngcGvt1N8tMvvLp/QqP1eZDVfS+CB4HruJhPgaV2T A1IbWsJQmx9f593h9yDALtzAriMqcWoq7m70NdXmSQ+h2ORfjdkTrBIQJ0cfx+3U487I IhXypQ3O4ZHUGTN7+mK5m2/xfugZ8FkJM4Bz9TQGMtrJ9/N+UiH5H4ryRxw4qFTisHbj yS/A== 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:content-transfer-encoding :in-reply-to:user-agent; bh=zGvuzlOUxTvQexb71qY5lh6nm7NdtrSLp8MDUk6D8V8=; b=BY1gSSeT7mfIwyWeZCYjyAqRTXX0cetos8LrryheHz/Z3QKaujJcCPCxnfHTI4bIhN 7H4Gq91FuLiOEmxbbSW+PwiT4F9llJKDwM5CT1o3ImDmBt/2JV6f2vCwoUjfZfIp7eVX 8wiFTNwEAHxPO88PHBBYbjW8B6yeyuYnfjcVGOL7UR+MgHCK3ThoQja89RGF1kthSEXY kllyBqqVizubl2qBpoYmKIBBcJsEfbCalO6Xixh2IcEuAkYO+ATujTNRXQqEemcayln5 2hlINmQhXip4TAF2w3eqpP2h9as+D7aWbktbD+hJjhb3uz1cS+QK3UtTpZ0xB4w8kLRq o93Q== X-Gm-Message-State: AOAM530ngzUwL4y7SvUdZYAivDUODDTjELovqH0SGW5ENCGOwESDGkKx 9HM145glytle4oweMKNMbVwSrqrFlLq1+w== X-Google-Smtp-Source: ABdhPJySPzJ5SFn6nt/7hh/mTQebtvxBM/8EX8c7aHiJy8bB1TxxwpyKKcYIczwUMylC2/JUQKLEPA== X-Received: by 2002:a05:6830:33ea:: with SMTP id i10mr27580434otu.212.1620771203695; Tue, 11 May 2021 15:13:23 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id s24sm3607601ooh.28.2021.05.11.15.13.22 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 11 May 2021 15:13:23 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 0603F8007F8; Tue, 11 May 2021 17:13:21 -0500 (CDT) Date: Tue, 11 May 2021 17:13:21 -0500 From: Justin Pryzby To: Bruce Momjian Cc: pgsql-hackers@postgresql.org Subject: Re: PG 14 release notes, first draft Message-ID: <20210511221321.GL27406@telsasoft.com> References: <20210510060308.GC6088@momjian.us> <20210510140005.GB27406@telsasoft.com> <20210511143523.GQ6088@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20210511143523.GQ6088@momjian.us> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, May 11, 2021 at 10:35:23AM -0400, Bruce Momjian wrote: > > | Allow more than the common name (CN) to be matched for client certificate authentication (Andrew Dunstan) > > Your description makes it sound like arbitrary attributes can be compared. But > > the option just allows comparing CN or DN. > > OK, new text is: > > > Allow the certificate's distinguished name (DN) to be matched for client > certificate authentication (Andrew Dunstan) > > > > The new pg_hba.conf keyword "clientname=DN" allows comparison with > non-CN certificate attributes and can be combined with ident maps. > > I think this part is still misleading. The option just allows DN/CN, so it's strange to say "non-CN attributes". > > | Add date_bin function (John Naylor) > > This truncate timestamps on an arbitrary interval. > > Like date_trunc() but also supports eg. '15 minutes', and also uses an arbitrary "origin". > > OK, so what I think it returns is the greatest datetime that is a > multiple of interval values added to origin which is not greater than > the target date, right? Am I the only one who finds this unclear? > Doesn't our documentation of this feature need to explain this? I think the documentation is okay, myself: https://www.postgresql.org/docs/devel/functions-datetime.html#FUNCTIONS-DATETIME-BIN | The function date_bin “bins” the input timestamp into the specified interval (the stride)... Anyway, the release notes have to be at least as succiently as that. +Allow VACUUM to eagerly add newly deleted btree pages in the free space map (Peter Geoghegan) say added "to" the FSM -- Justin