Re: PG 10 release notes

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: amborodin(at)acm(dot)org
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PG 10 release notes
Date: 2017-05-04 23:23:32
Message-ID: 20170504232332.GB29760@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)momjian(dot)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(at)sss(dot)pgh(dot)pa(dot)us>
2016-09-09 [b1328d78f] Invent PageIndexTupleOverwrite, and
teach BRIN and GiST

Allow faster <acronym>GiST</> inserts and updates by reusing
index space more efficiently (Andrey Borodin)

--
Bruce Momjian <bruce(at)momjian(dot)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 +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2017-05-04 23:26:56 Re: PG 10 release notes
Previous Message Petr Jelinek 2017-05-04 22:48:59 Re: logical replication syntax (was DROP SUBSCRIPTION, query cancellations and slot handling)