PostgreSQL 8.4 Proves Feature-Rich
The free database system PostgreSQL is available in version 8.4 with numerous new features and enhancements.
The PostgreSQL Group counts 293 enhancements for its 8.4 release over its predecessor. Among the most important is Parallel Restore, with up to eight times faster backup file restoration, which can apply to 8.2 and 8.3 backups as well. As far as database security, column-level permissions can now be set along with the table itself.
The sorting methods (character collations) can be set by database apart from at installation, a welcome feature for multilingual environments. A few new monitoring features will also be helpful for large enterprise environments.
The query language was enhanced through advanced features of the SQL 2003 ANSI standard, such as aggregate operations through windowing. Common table expressions allowing named subqueries and recursive joins also reduce queries to far fewer than previously required.
An overview of the PostgreSQL 8.4 feature enhancements is available as a list or a matrix comparing it to the previous five releases.
PostgreSQL is ready for download under a BSD license. Apart from the source code, there are binary packages for 32-bit and 64-bit Intel CPUs, with specific distro packages also in the offering.
Issue 237/2020
Buy this issue as a PDF
News
-
openSUSE Leap 15.2 Adds AI Machine Learning
With the new release of openSUSE Leap comes some exciting new features, including machine learning.
-
Google’s Nearby Sharing Could Work with Linux
Google’s answer to Apple’s AirDrop feature is rumored to work with the Linux desktop.
-
System76 Launches Ryzen-Powered Laptop
The new System76 Serval WS includes a powerful AMD Ryzen CPU.
-
Linux Mint Drops Snap
Linux Mint has officially dropped their support for Canonical’s snap packages.
-
Lenovo Upping Their Linux Support
Lenovo is now offering full certification and Linux preinstalled hardware.
-
LPI Launches FOSSlife Website
Linux Professional Institute launches FOSSlife, a website for the FOSS community.
-
Tuxedo Computers Joins the Ryzen Bandwagon
Tuxedo Computers has released the Tuxedo Boot BA15 with an AMD Ryzen 3500 CPU.
-
Linux Apps on Windows Is Coming
Linux GUI apps will be coming to Windows Subsystem for Linux.
-
Linux Usage Is on the Rise
According to NetMarketShare, Linux saw a significant bump in usage during April.
-
Lenovo is Jumping on the Linux Laptop Bandwagon
PC and laptop maker Lenovo is set to release ThinkPad laptops pre-installed with Fedora Linux.