An object-relational database management system with an emphasis on extensibility and standards compliance.
Beta release of PostgreSQL 10 contains previews of all of the features which will be available in the final release of version 10, but some details can change. Developers ask users to begin testing their applications with this latest release.
The new version has some good features that will allow users to both scale out and scale up their PostgreSQL infrastructure:
- Logical Replication: built-in option for replicating specific tables or using replication to upgrade
- Native Table Partitioning: range and list partitioning as native database objects
- Additional Query Parallelism: including index scans, bitmap scans, and merge joins
- Quorum Commit for Synchronous Replication: ensure against loss of multiple nodes
Also, users will be able to test:
- SCRAM Authentication, for more secure password-based access
- Multi-host "failover", connecting to the first available in a list of hosts
- target_session_attrs parameter, so a client can request a read/write host
Many other new features and improvements have been added to PostgreSQL 10. All of them require testing. Among them are:
- Crash-safe and replicable Hash Indexes
- Multi-column Correlation Statistics
- New "monitoring" roles for permission grants
- Latch Wait times in pg_stat_activity
- XMLTABLE query expression
- Restrictive Policies for Row Level Security
- Full Text Search support for JSON and JSONB
- Compression support for pg_receivewal
- ICU collation support
- Push Down Aggregates to foreign servers
- Transition Tables in trigger execution
Further, developers have contributed performance improvements in the SUM() function, character encoding conversion, expression evaluation, grouping sets, and joins against unique columns. Analytics queries against large numbers of rows should be up to 40% faster. Please test if these are faster for you and report back.
See the Release Notes for a complete list of new and changed features.
The final release planned in late 2017.