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 43_SI: LibreOffice Expert/Special Editions
Buy this issue as a PDF
News
-
EndeavorOS 21.4 Has Arrived
Arch-based EndeavorOS 21.4 is finally available for download with plenty of new features and improvements.
-
NixOS 21.11 Now Available for Download
NixOS “Porcupine” has been made available for installation and includes numerous improvements.
-
KDE Plasma Developers Introduce a GNOME-Like Overview
A new overview effect makes it easier for users to interact with both Plasma Activities and Virtual Desktops.
-
Rocky Linux 8.5 Now Available with Secure Boot Support
The latest iteration of CentOS alternative, Rocky Linux has arrived and includes numerous updates as well as support for Secure Boot.
-
System76 Developing a New Desktop Environment
The makers of Pop!_OS are currently in the early stages of creating a brand new, non-GNOME, desktop environment.
-
Hetzner Opens New Location in the USA
The Hetzner cost-effective Cloud solution has arrived in the United States to offer cloud servers that offer solid performance without a high price.
-
KDE Plasma 5.24 Introduces Fingerprint Reader Support
The next release of the KDE Plasma desktop environment will include support for fingerprint readers for session authentication and more.
-
Ubuntu 21.10 Released and Finally Includes Gnome 40
The most anticipated update to Ubuntu is finally here and the workflow couldn't be better.
-
Linux Can Now Run on Apple’s M1 Chipset
Linux users looking to take advantage of Apple Silicon are about to get their wish with the M1 chipset.
-
MX Linux 21 RC Candidate Available For Testing
The MX Linux development team has released the RC images for MX Linux 21 for testing purposes.