Re: [pgsql-advocacy] Assembling "top features" list for betaannouncement - Mailing list pgsql-advocacy

On 4/7/17 20:40, Josh Berkus wrote:
> So, lemme update the running list:
>
> Banner Features:
>
> - pglogical
> - new partitioning
> - quorum sync rep
> - parallel index scan, bitmap scan, and merge join
>
> Other Features:
>
> - XMLTABLE query expressions
> - hash indexes in wal
> - PGFDW: push down aggregates
> - SCRAM authentication
>
> ... seems like the "other features" list should be longer.

Some more possibilities:

- better defaults for replication/online backups out of the box
- ICU support
- extended statistics (better performance for certain queries?)
- executor performance improvements

Also note that parallel query is now on by default, whereas it was
disabled by default in 9.6.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services