Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gBUFk-0004Kw-PR for pgsql-hackers@arkaria.postgresql.org; Sun, 14 Oct 2018 00:27:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gBUFg-0005jD-7M for pgsql-hackers@arkaria.postgresql.org; Sun, 14 Oct 2018 00:27:24 +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.89) (envelope-from ) id 1gBUFf-0005j6-QT for pgsql-hackers@lists.postgresql.org; Sun, 14 Oct 2018 00:27:24 +0000 Received: from mail-it1-x132.google.com ([2607:f8b0:4864:20::132]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gBUFY-0001ub-Df for pgsql-hackers@postgresql.org; Sun, 14 Oct 2018 00:27:22 +0000 Received: by mail-it1-x132.google.com with SMTP id p64-v6so23005030itp.0 for ; Sat, 13 Oct 2018 17:27:15 -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=XCbuKfEiqV//ubhC3qOaq0/3PDH3+5qnLzhiHupG5Ew=; b=kv+r6lWTI2EDb9n3fbs9F4cUUvofOYrTdJgHCttP5XmlBSQcrtm0kilXviBlWP+0Gb vs1zCSoNmYCd9vMKRJDJGtPeE75wXW13tQDaqY/DPrt6FzYmGMatoVSpde4t1wDNDue5 8dW0SFcSVTohgHA/PbGfFRS4BsK/Siuzq3ArnLR3N6D4/gL9LWXJ9MQZ8KfFG8jwsPsU IRifhX+8D+ZVaCU0fRoZIJJ40SPYhWbkYa4k2mKHHDxJz1vLNFWrsGPJUsfUqNS3B1Li rZPP+u0kmkQBbu+iSsnsSPtb3FeXWlf+SE3HK4zqGxagOU2Shw93oavwtWwt+w2N43ts 30TQ== 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=XCbuKfEiqV//ubhC3qOaq0/3PDH3+5qnLzhiHupG5Ew=; b=Ys/HJx2T4VmaCSmLxW4YPkVyrLKsImw5Q8ZgVZqTPST985Lg0hlVji+ni9COx3CjWR jj8pBY+uPOQqQ4rhhdHOvbQMMib3mCLteS6gnlB62V+9DX17p6GbkiW6SZyFAbD/71do nKmx8FuQJcXcx02w2UDAFfpjGNnI5Iccv/qpvwyMVjsU9v0Wr4vDpMcyclsG5U1Cjo3b ATV+gcDET12w1/9kaZtH2XOUOj6HW8EaHqhqOoQt7QY2xvqIE3qE/lnuuq2zzCUZiIkm LH2AovwmQ/KeeK5+KTyUbuirnk0d0PNRFK16mzhVx0yslZ/V/VJJp0MJy9rsvgpcgYUC xFBw== X-Gm-Message-State: ABuFfoj8pTHPC0gX7LFCgtATA1qW/esS0g/CoR4KHAJHYtd8b0VknzO5 B+0SUmYhkqnOunfKL0+wWnYc9w== X-Google-Smtp-Source: ACcGV62RoCRSUge+d5Y3XCc9G1UNV4OPi2r1zFv+Ceam+NWuCU7hN7I9qpmdbYP5l/RKJup6NLHmgg== X-Received: by 2002:a24:3cc5:: with SMTP id m188-v6mr8707782ita.85.1539476832961; Sat, 13 Oct 2018 17:27:12 -0700 (PDT) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id r202-v6sm1874430iod.28.2018.10.13.17.27.12 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sat, 13 Oct 2018 17:27:12 -0700 (PDT) Received: by pryzbyj (Postfix, from userid 1000) id 2EA2D804FC9; Sat, 13 Oct 2018 19:27:11 -0500 (CDT) Date: Sat, 13 Oct 2018 19:27:11 -0500 From: Justin Pryzby To: Tom Lane Cc: "Jonathan S. Katz" , pgsql-hackers@postgresql.org, Bruce Momjian Subject: Re: fine tune v11 release notes Message-ID: <20181014002711.GJ23241@telsasoft.com> References: <20181006134249.GD871@telsasoft.com> <24ecf60a-851e-35d2-e5d4-458eb645d1b9@postgresql.org> <22578.1539462847@sss.pgh.pa.us> <20181013203839.GH23241@telsasoft.com> <20181013210430.GA5325@telsasoft.com> <24849.1539466306@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="FCuugMFkClbJLl1L" Content-Disposition: inline In-Reply-To: <24849.1539466306@sss.pgh.pa.us> User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --FCuugMFkClbJLl1L Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, Oct 13, 2018 at 05:31:46PM -0400, Tom Lane wrote: > Justin Pryzby writes: > >> On Sat, Oct 13, 2018 at 04:34:07PM -0400, Tom Lane wrote: > >>> Hmm, I just saw this after spending an afternoon editing the release > >>> notes. I'll try to merge it with what I did. > > > Feel free to send your own patch and I'll resolve conflicts and resend proposed > > changes. > > I've pushed updates merging Jonathan's last with my work. Please > look over what's in HEAD and see if you want to propose additional > changes. Find attached what's left. Justin --FCuugMFkClbJLl1L Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="fine-tune-v4.patch" diff --git a/doc/src/sgml/release-11.sgml b/doc/src/sgml/release-11.sgml index 188222f..cdf41af 100644 --- a/doc/src/sgml/release-11.sgml +++ b/doc/src/sgml/release-11.sgml @@ -31,8 +31,8 @@ - Add support for PRIMARY KEY, FOREIGN - KEY, indexes, and triggers on partitioned tables + Add support on partitioned tables for PRIMARY + KEY, FOREIGN KEY, indexes, and triggers @@ -65,7 +65,7 @@ CREATE INDEX can now use parallel processing - while building B-tree indexes + while building a B-tree index @@ -117,9 +117,9 @@ - Many other useful performance improvements, including a significant - speedup to ALTER TABLE ... ADD COLUMN with a - non-null column default, as it no longer rewrites the table data + Many other useful performance improvements, including the ability to avoid + a table rewrite when using ALTER TABLE .. ADD COLUMN + with a non-null column default. @@ -587,15 +587,18 @@ --> - Allow indexes on a partitioned table to be automatically created - in new child partitions (Álvaro Herrera) + Support indexes on partitioned tables (Álvaro Herrera) + + + + This is not a global index, but rather a mechanism to create an indexes + on each partition of a partitioned table. The new command ALTER - INDEX ATTACH PARTITION allows indexes to be - attached to partitions. This does not behave as a global index - since the contents are private to each index. + INDEX ATTACH PARTITION allows an index on a partition + to be inherited by the index on its partitioned table. @@ -733,8 +736,8 @@ --> - Perform aggregation on each partition, and then merge the results - (Jeevan Chalke, Ashutosh Bapat, Robert Haas) + Allow aggregate functions on partitioned tables to be evaluated + directly on partitions. (Jeevan Chalke, Ashutosh Bapat, Robert Haas) @@ -1101,8 +1104,8 @@ same commits as above --> - Improve optimizer's row count estimates for EXISTS - and NOT EXISTS queries (Tom Lane) + Improve row count estimates for EXISTS and + NOT EXISTS queries (Tom Lane) @@ -1146,7 +1149,7 @@ same commits as above This feature requires LLVM to be - available. It is not currently enabled by default, even in + available. It is disabled by default, even in builds that support it. @@ -1564,11 +1567,11 @@ same commits as above Allow server options related to memory and file sizes to be - specified as a number of bytes (Beena Emerson) + specified in units of bytes (Beena Emerson) - The new unit is B. This is in addition to the + The new suffix is B. This is in addition to the existing units kB, MB, GB and TB. @@ -1605,7 +1608,7 @@ same commits as above --> - Retain WAL data for only a single checkpoint + Retain WAL data for a single checkpoint, only. (Simon Riggs) @@ -1801,6 +1804,7 @@ same commits as above +DOES THIS NEED TO BE IN "COMPATIBILITY NOTES"? Also, if any table mentioned in VACUUM uses a column list, then the ANALYZE keyword must be supplied; previously, ANALYZE was implied in @@ -2199,8 +2203,7 @@ same commits as above Add psql command \gdesc - to display the column names and types of the query output (Pavel - Stehule) + to display the names and types of the columns in query results (Pavel Stehule) --FCuugMFkClbJLl1L--