Re: Top features in 9.6?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Josh berkus <josh(at)agliodbs(dot)com>
Cc: PostgreSQL Advocacy Group <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Top features in 9.6?
Date: 2016-04-12 02:46:50
Message-ID: 20160412024650.GH10850@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

* Josh berkus (josh(at)agliodbs(dot)com) wrote:
> So, let's make a list.
>
> Mine:
>
> * parallel query (seqscan & aggregation)
> * bloom filter supporting indexes
>
> The generic progress reporting framework is tempting, but seems hard to
> explain as a marquee feature. What else have we got?

I like the progress reporting, we need to do that with a lot more stuff.

postgres_fdw join pushdown is pretty huge.

Relation extension speed improvements are pretty huge too.

snapshot_too_old is quite important in some environments.

Degree-based geometry funcs
Phrase full text search
jsonb_insert
Index-only scans with partial indexes was improved
synch_commit = 'remote_apply'

...

Thanks!

Stephen

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Darren Duncan 2016-04-12 02:47:16 Re: Top features in 9.6?
Previous Message David G Johnston 2016-04-12 02:25:21 Re: 9.6 -> 10.0