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 260/2022
Buy this issue as a PDF
News
-
System76 Teams up with HP to Create the Dev One Laptop
HP and System76 have come together to develop a new laptop, powered by Pop!_OS and aimed toward developers.
-
Titan Linux is a New KDE Linux Based on Debian Stable
Titan Linux is a new Debian-based Linux distribution that features the KDE Plasma desktop with a focus on usability and performance.
-
Danielle Foré Has an Update for elementary OS 7
Now that Ubuntu 22.04 has been released, the team behind elementary OS is preparing for the upcoming 7.0 release.
-
Linux New Media Launches Open Source JobHub
New job website focuses on connecting technical and non-technical professionals with organizations in open source.
-
Ubuntu Cinnamon 22.04 Now Available
Ubuntu Cinnamon 22.04 has been released with all the additions from upstream as well as other features and improvements.
-
Pop!_OS 22.04 Has Officially Been Released
From the makers of some of the finest Linux-powered desktop and laptop computers on the market comes the latest version of their Ubuntu-based distribution, Pop!_OS 22.04.
-
Star Labs Unveils a New Small Format Linux PC
The Byte Mk I is an AMD-powered mini Linux PC with Coreboot support and plenty of power.
-
MX Linux Verison 21.1 “Wildflower” Now Available
The latest release of the systemd-less MX Linux is now ready for public consumption.
-
Microsoft Expands Their Windows Subsystem for Linux Offerings With AlmaLinux
Anyone who works with Windows Subsystem for Linux (WSL) will now find a new addition to the available distributions, one that’s become the front-runner replacement for CentOS.
-
Debian 11.3 Released wIth Numerous Bug and Security Fixes
The latest point release for Debian Bullseye is now available with some very important updates.