On Mon, Jun 22, 2015 at 09:14:01PM +0000, Rajeev rastogi wrote:
> On 11 June 2015 09:45, Bruce Momjian Wrote:
>
> >
> > I have committed the first draft of the 9.5 release notes. You can
> > view the output here:
> >
> > http://momjian.us/pgsql_docs/release-9-5.html
> >
> > and it will eventually appear here:
> >
> > http://www.postgresql.org/docs/devel/static/release.html
> >
> > I am ready to make suggested adjustments, though I am traveling for
> > conferences for the next ten days so there might a delay in my replies.
>
> Below performance improvement in the "General Performance" category is missing:
>
> Reduce btree scan overhead for < and > strategies
>
> For <, <=, > and >= strategies, mark the first scan key
> as already matched if scanning in an appropriate direction.
> If index tuple contains no nulls we can skip the first
> re-check for each tuple.
While this is a nice 9.5 feature, it really is "btree is faster", and
users usually don't need to know that, unless the change is massive that
they would change their use of the feature.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ Everyone has their own god. +
