Re: Top features in 9.6? - Mailing list pgsql-advocacy

From Stephen Frost
Subject Re: Top features in 9.6?
Date
Msg-id 20160412024650.GH10850@tamriel.snowman.net
Whole thread Raw
In response to Top features in 9.6?  (Josh berkus <josh@agliodbs.com>)
Responses Re: Top features in 9.6?  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List pgsql-advocacy
* Josh berkus (josh@agliodbs.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

Attachment

pgsql-advocacy by date:

Previous
From: David G Johnston
Date:
Subject: Re: 9.6 -> 10.0
Next
From: Darren Duncan
Date:
Subject: Re: Top features in 9.6?