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.
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Support Our Work
Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.
News
-
Fedora Asahi 40 Remix Available for Macs with Apple Silicon
If you've been anticipating KDE's Plasma 6 for your Apple Silicon-powered Mac, then you're in luck.
-
Red Hat Adds New Deployment Option for Enterprise Linux Platforms
Red Hat has re-imagined enterprise Linux for an AI future with Image Mode.
-
OSJH and LPI Release 2024 Open Source Pros Job Survey Results
See what open source professionals look for in a new role.
-
Proton 9.0-1 Released to Improve Gaming with Steam
The latest release of Proton 9 adds several improvements and fixes an issue that has been problematic for Linux users.
-
So Long Neofetch and Thanks for the Info
Today is a day that every Linux user who enjoys bragging about their system(s) will mourn, as Neofetch has come to an end.
-
Ubuntu 24.04 Comes with a “Flaw"
If you're thinking you might want to upgrade from your current Ubuntu release to the latest, there's something you might want to consider before doing so.
-
Canonical Releases Ubuntu 24.04
After a brief pause because of the XZ vulnerability, Ubuntu 24.04 is now available for install.
-
Linux Servers Targeted by Akira Ransomware
A group of bad actors who have already extorted $42 million have their sights set on the Linux platform.
-
TUXEDO Computers Unveils Linux Laptop Featuring AMD Ryzen CPU
This latest release is the first laptop to include the new CPU from Ryzen and Linux preinstalled.
-
XZ Gets the All-Clear
The back door xz vulnerability has been officially reverted for Fedora 40 and versions 38 and 39 were never affected.