Re: [HACKERS] PG 10 release notes - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] PG 10 release notes
Date
Msg-id 20170504232332.GB29760@momjian.us
Whole thread Raw
In response to Re: [HACKERS] PG 10 release notes  (Andrew Borodin <borodin@octonica.com>)
List pgsql-hackers
On Thu, Apr 27, 2017 at 10:21:44AM +0500, Andrew Borodin wrote:
> Hi, Bruce!
> 
> 2017-04-25 6:31 GMT+05:00 Bruce Momjian <bruce@momjian.us>:
> > The only unusual thing is that this release has ~180 items while most
> > recent release have had ~220.  The pattern I see that there are more
> > large features in this release than previous ones.
> 
> I'm not sure, but, probably, it worth mentioning this [1,2] in the
> E.1.3.1.2. Indexes section.
> Better tuple management on GiST page allows faster inserts and
> updates. (In numbers: 15% for randomized data,3x for ordered data in
> specific cases)
> 
> [1] https://commitfest.postgresql.org/10/661/
> [2] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b1328d78f88cdf4f7504004159e530b776f0de16

OK, got it.  Here is the new item:
      Author: Tom Lane <tgl@sss.pgh.pa.us>      2016-09-09 [b1328d78f] Invent PageIndexTupleOverwrite, and      teach
BRINand GiST
 
      Allow faster <acronym>GiST</> inserts and updates by reusing      index space more efficiently (Andrey Borodin)

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: [HACKERS] logical replication syntax (was DROP SUBSCRIPTION,query cancellations and slot handling)
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] PG 10 release notes