PostgreSQL9.6 new Features

PostgreSQL is the most advanced open source database in the world, and the latest version of 9.6 is released today by PostgreSQL Global developers. This release will allow user scale-out (scale-up) and scale-out (scale-out) to improve the query performance of the database. New features include parallel query, synchronous replication improvements, phrase search, performance and usability improvements, and many other aspects of functionality.

Vertically scaled parallel queries

Version 9.6 now supports some parallel query operations, allowing you to perform operations using several or all of the CPU cores on the server, which results in faster return queries. This version of parallel functionality includes parallel sequential table scans, aggregations, and joins. Depending on the details and available cores, parallelism can speed up big data queries up to 32 times times faster.

"We migrated our entire genome data platform – 25 billion rows of old MySQL data to a postgres database, leveraging the JSONB data type of row compression," said Mike Sofen, chief Database architect for Synthetic genomics. As well as excellent gin,brin and b-tree indexing modes. Look forward to the 9.6 version, the use of parallel query function, when we query large table data, have more robust scalability, better query performance "

Scale-out synchronous replication and POSTGRES_FDW

PostgreSQL's synchronous replication feature adds two options that enable it to be used for consistent read maintenance of the database cluster. First, it now allows you to configure a set of replicated databases for synchronization. Second, the "remote_apply" mode creates a consistent read view of multiple cross-data nodes. These features use built-in replication to maintain a set of "same" node implementations that can be used for read load balancing of the database.

The POSTGRES_FDW (Postgresql-to-postgresql Data External Table driver) provides new features that enable operations on remote servers. With push-down sorting (sort), join join, bulk data Updates (update) Tasks, users can schedule multiple PostgreSQL servers to complete data queries. These features are quickly added to other FDW modules.

Julyanto Sutandang, director of Business Solutions at Equnix, said, "FDW supports remote joins, updates, and deletions, and is a complete solution for sharing data with other databases and PostgreSQL today. For example, PostgreSQL can achieve the ability to save data entered into two or more different types of databases "

A better text phrase search

The full-text search feature of PostgreSQL now supports phrase search. This allows users to search for exact phrases, or to search for phrases with a certain similarity, to use the words in a fast gin index, and to combine the new features of fine-tuned text search options, PostgreSQL is an excellent choice for "hybrid search", with integrated relational tables, JSON, and full-text search support.

Easier, faster and easier to use

Thanks to the large number of PostgreSQL users who use their large data production database for PostgreSQL feedback and testing, this version includes a lot of content on performance improvements and usability. Replication, aggregation, indexing, sequencing, and stored procedures become more efficient, and PostgreSQL can now make better use of resources on the new Linux kernel, reducing the system load of large table queries and complex queries, especially vacuum improvements.

Other features

The 9.6 release has a lot of new features in the past year, mainly including:

• New system views and functions: Pg_stat_wal_receiver,pg_visbility,pg_config,pg_blocking_pids,pg_notification_queue_usage

• Support for command execution progress status reporting

• Supports cascading operations (requires installation of extension implementations)

• Support for Pg_basebackup concurrency

• Logical Copy Slots

• Wait for event support

• Edit views and crosstabs in Psql

• User-defined old snapshot expires

• Scan only Local indexes

PostgreSQL9.6 new Features