In focus

Beta 4 of the upcoming version 10 of PostgreSQL released

Ahead of the launch of Version 10, PostgreSQL Global Development Group releases Beta 4; available for download now.

Kopal Chaube Dutta Sep 15, 2017

The PostgreSQL Global Development Group announced the fourth beta release of PostgreSQL 10 on 31 August 2017.Beta 4 is now available for download and contains previews of the features which will be available in the final release of version 10.
It claims to provide fixes of many of the issues found in the third beta. The group is encouraging users to begin testing their applications against 10 beta 4.
Major enhancements in PostgreSQL 10 include:
• Logical replication using publish/subscribe
• Declarative table partitioning
• Improved query parallelism
• Significant general performance improvements
• Stronger password authentication based on SCRAM-SHA-256
• Improved monitoring and control
Please read the Release Notes for details.
PostgreSQL 10 beta 4 requires an upgrade from beta 3, or earlier version by either using pg_dump / pg_restore or pg_upgrade.
Bugfixes applied to 9.6 or earlier and specific fixes for bugs reported against 10 beta 3 are included in beta 4. As per the official release by PostgreSQL, some important fixes include
• Show foreign tables in information_schema.table_privileges view (applicable in new database)
• Clean up handling of a fatal exit (e.g., due to receipt of SIGTERM) that occurs while trying to execute a ROLLBACK of a failed transaction
• Remove assertion that could trigger during a fatal exit
• Correctly identify columns that are of a range type or domain type over a composite type or domain type being searched for
• Prevent crash when passing fixed-length pass-by-reference data types to parallel worker processes
• Fix crash in pg_restore when using parallel mode and using a list file to select a subset of items to restore
• Change ecpg’s parser to allow RETURNING clauses without attached C variables
• Change ecpg’s parser to recognize backslash continuation of C preprocessor command lines
• Improve selection of compiler flags for PL/Perl on Windows
• Fix to make check to behave correctly when invoked via a non-GNU make program’
• However, the group has issued a disclaimer saying that some known issues remain unfixed which are listed in the Open Items page.
According to the official website, this is the fourth beta release of version 10. The PostgreSQL Project announced that it will release additional betas if required for testing, followed by one or more release candidates, until the final release of version 10 in late 2017.

Kopal Chaube Dutta
Kopal Chaube Dutta

Racing up to the finish line of my doctorate degree, i am a passionate researcher and writer in search of new challenges. Totally in love with technology and in constant pursuit of new knowledge, my flight brings me to ... Read more