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 1ly3Rj-0008MH-HV for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Jun 2021 02:25:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ly3Ri-0002aX-Er for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Jun 2021 02:25:54 +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 1ly3Ri-0002aP-77 for pgsql-hackers@lists.postgresql.org; Tue, 29 Jun 2021 02:25:54 +0000 Received: from mail-il1-x129.google.com ([2607:f8b0:4864:20::129]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ly3Re-0002yk-Px for pgsql-hackers@postgresql.org; Tue, 29 Jun 2021 02:25:53 +0000 Received: by mail-il1-x129.google.com with SMTP id h3so19428105ilc.9 for ; Mon, 28 Jun 2021 19:25:50 -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=1WBwN8kdU5VhGGsQDl6T0ufhL6TuDRFkmghx/QiG3+U=; b=uE4DN/po9MZUV2KRfAMHkodH1c+imk/t5OER0+P9JvK9c1o39U2qYXXbZDoGye0nQw zUEzyzfojwNUnhtzBcqRG0XkXbXdl6wYNmwFgaBG1e3Am93lhjsmSyNr5SWezfWoEZ72 sliRqCz6tWGByGzmVcBIxlOwtK9/VrYzWLGMEpSgM5VN2TkEY7q2igMTTXmA7+YK7kt8 RSpc4E8/2c+nS/wQS0X5GnpIazsK4Sh+6B6dBrdulx/YIdo/BE/L1rIz3Wyy2j5RI/T/ 2rpv1iuXh45EazFz/Bjw/BFIQL+wCbtPMcVSvkWo7onUjG3QGwvFII9P7fNtEJlZ34TD SShg== 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=1WBwN8kdU5VhGGsQDl6T0ufhL6TuDRFkmghx/QiG3+U=; b=tEgS4lMgeB0FbSxLMHCkunotAPvww+wsZG+tbQsUBnzNXUudTxU3VLKSiekNKxxQmS KaslQotDcsd8333EOUW27ILLahG9nMqnfVxV2+ttHe5cAxCR7XnHmfCqiO/sMe+XZWE4 WTk0D9ud3RO+30OmLIwqJOiKUjDQzpWGKuJz6Jh1k7Z0eyu3hWraFx3sH2GMugcgppgF 5+RN6tyxeqrzd4ctDOhKT5BVlW88viHdSpNF9Hrn0hThOyxOyHg0HR5+28VK62XWldjO kGvRqK/KB3u3qb6CyBSofO8CO17SKYJO4fh2KbFe+3mw7PFvwaAgUid3Yn9xEqIYxFEM 3/Iw== X-Gm-Message-State: AOAM531P46s7wwWSPIlpkxoEG5u1WG7nSHJzbT/HObvIXuZ5OoFVZuJD 2HP0sXFpMOZ20723iiri3Al83w== X-Google-Smtp-Source: ABdhPJzjLtLfcOf+fkuhBZZGipGCr3we6khstG3nzY/vQbGqr2kBYDktcAcdrQw+/5D2tmLiPh9Q+g== X-Received: by 2002:a92:6d0b:: with SMTP id i11mr20220564ilc.160.1624933549406; Mon, 28 Jun 2021 19:25:49 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id w21sm9575566iol.52.2021.06.28.19.25.48 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 28 Jun 2021 19:25:48 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 9E35B8007F2; Mon, 28 Jun 2021 21:25:47 -0500 (CDT) Date: Mon, 28 Jun 2021 21:25:47 -0500 From: Justin Pryzby To: Bruce Momjian Cc: pgsql-hackers@postgresql.org Subject: Re: PG 14 release notes, first draft Message-ID: <20210629022547.GF21248@telsasoft.com> References: <20210510060308.GC6088@momjian.us> <20210625230456.GP29179@telsasoft.com> <20210629010140.GA32681@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20210629010140.GA32681@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 Mon, Jun 28, 2021 at 09:01:40PM -0400, Bruce Momjian wrote: > On Fri, Jun 25, 2021 at 06:04:56PM -0500, Justin Pryzby wrote: > > > The postgres_fdw supports these type of scans if async_capable is set. > > this type > > remove "The" ? > > New text is: > > linkend="postgres-fdw">postgres_fdw > supports these type of scans if async_capable > > I kept "these types" because the paragraph above says: > > Allow a query referencing multiple linkend="sql-createforeigntable">foreign tables to perform > foreign table scans in parallel (Robert Haas, Kyotaro Horiguchi, > Thomas Munro, Etsuro Fujita) > > so we are talking about scans in parallel, so I think it is plural. Wrong? I think the "type" of scan being referenced is a "parallel" type, right ? So there's only one type, but multiple scans. So I think it should say "this type" of scan, but it seems like it's not only easier but generally better to say | postgres_fdw supports parallel scans if async_capable >> Prevent the containment operators (<@ and @>) for intarray from using GiST indexes (Tom Lane) >> Remove deprecated containment operators @ and ~ for built-in geometric data types and contrib modules cube, hstore, intarray, and seg (Justin Pryzby) >> For example, disregard ^ in its expansion in \1 in (^\d+).*\1. >> Add point operators <<| and |>> to be strictly above/below geometry (Emre Hasegeli) >> Previously >^ and <^ were marked as performing this test, but non-point geometric operators used these operators for non-strict comparisons, leading to confusion. The old operators still exist but will be eventually removed. > What markup is missing? I mean markup for the operators, like <@ > > > Add primary keys, unique constraints, and foreign keys to system catalogs (Peter Eisentraut) > > > Should mention and link to pg_get_catalog_foreign_keys() > > Uh, why? I don't see the release notes as a place to explain how to use > Postgres features. Because the normal way to show foreign keys (\d) doesn't show them - the references are shown by the function. Thanks, -- Justin