Language Selection

English French German Italian Portuguese Spanish

PostgreSQL 14 Released!

Filed under
Server

The PostgreSQL Global Development Group today announced the release of PostgreSQL 14, the latest version of the world’s most advanced open source database.

PostgreSQL 14 brings a variety of features that help developers and administrators deploy their data-backed applications. PostgreSQL continues to add innovations on complex data types, including more convenient access for JSON and support for noncontiguous ranges of data. This latest release adds to PostgreSQL's trend on improving high performance and distributed data workloads, with advances in connection concurrency, high-write workloads, query parallelism and logical replication.

"This latest release of PostgreSQL advances our users' ability to manage data workloads at scale, enhances observability, and contains new features that help application developers," said Magnus Hagander, a PostgreSQL Core Team member. "PostgreSQL 14 is a testament to the dedication of the global PostgreSQL community in addressing feedback and continuing to deliver innovative database software that is deployed by organizations large and small."

PostgreSQL, an innovative data management system known for its reliability and robustness, benefits from over 25 years of open source development from a global developer community and has become the preferred open source relational database for organizations of all sizes.

Read more

In Phoronix, by Michael Larabel

  • PostgreSQL 14.0 Released With More Performance Improvements

    PostgreSQL 14.0 is now officially available as the latest version of this widely-used, open-source SQL server.

    As with most major PostgreSQL releases, PostgreSQL 14 brings more performance improvements. In particular there are new optimizations around parallel queries, heavily-concurrent workloads, partitioned tables, logical replication, and vacuuming. PostgreSQL 14 also has B-tree index updates so they are managed more efficiently. PostgreSQL 14's libpq library also now allows for pipelining multiple queries to improve throughput over high latency connections.

PostgreSQL Global Temporary Tables extension v2.6 released

  • PostgreSQL Global Temporary Tables extension v2.6 released

    pgtt is a PostgreSQL extension to create, manage and use Oracle-style Global Temporary Tables.

    The main interest of this extension is to reproduce Oracle behavior with GTT when you can not or don't want to rewrite the application code when migrating to PostgreSQL. In all other case best is to rewrite the code to use standard PostgreSQL temporary tables.

    This is a maintenance release to add support for upcomming PostgreSQL 1

PostgreSQL 14 released

PostgreSQL 14 Ships with Improved Performance for Heavy Workload

  • PostgreSQL 14 Ships with Improved Performance for Heavy Workloads

    The PostgreSQL team released the PostgreSQL 14 database, providing users of the widely deployed relational database with new features.

    PostgreSQL, also known as “Postgres”, is an open-source, object-relational database management system. It has been around for over 30 years and advertises itself as “the most advanced open-source relational database in the world”. It is developed by a worldwide team of volunteers and it is quite popular due to its stability and advanced features.

    PostgreSQL is perceived as a go-to solution for performing complicated, high-volume data operations. That’s because PostgreSQL is better at handling extraordinary database situations. Additional points that set PostgreSQL apart are the fact it is object-relational, ACID-compliant, highly concurrent, and offers NoSQL support. And the latest PostgreSQL 14 makes things even better.

Open-source veteran PostgreSQL emits release 14

  • Open-source veteran PostgreSQL emits release 14: Tweaked, scalable, and ready to get heavy

    Open-source database fans were given reason to celebrate this week with the release of PostgreSQL 14, an iteration of the RDBMS featuring performance improvements for heavy and distributed workloads.

    The seasonal autumn release was posted yesterday, and though PostgreSQL 14 may not include a set of big wow new features, more than 220 updates add up to performance improvements for high-end systems, said Umair Shahid, head of PostgreSQL at open-source technology consultancy Percona.

    "The sheer number of additional features is significantly larger, but no single feature carries the entire release. The release focuses on the performance of the database: not just the database internals performing better, but also the SQL queries running faster and a focus on parallelism," Shahid said.

    While PostgreSQL was designed as a vertically scaling database, the open-source community has been focused on trying to implement features that help with horizontal scalability, which makes it much easier to scale applications and improve database performance, he said.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

More in Tux Machines

SSH Key Rotation with the POSIX Shell - Sunset Nears for Elderly Keys

OpenBSD has recently stressed to us the value of key rotation by their use of “Signify” distribution release signatures. We have realized that SSH keys should also rotate, to reduce the risk of powerful keys that fall into the wrong hands which become “the gift that keeps on giving.” There have always been open questions on the retirement of SSH keys. These questions have grown in volume and many are joining the advocacy for SSH certificate authorities. To “rotate” an SSH key is to replace it, in such a way that it is no longer recognized, requiring removal from the authorized_keys file. SSH rotation is commonly addressed with Ansible, but this leaves many users on smaller systems or lacking privilege without recourse. A more basic and accessible method to migrate SSH keys is sorely lacking. Below is presented an SSH key rotation script written in nothing more than the POSIX shell. There is palpable danger in the misuse of such a tool. Many administrators control inaccessible systems that entail massive inconvenience in a loss of control. Demonstrated here are rotation schemes of increasing risk, for any holder of a key to choose, to their own tolerance. Hopefully, I have not made grave mistakes in the design. The most conservative users of this approach should tread with extreme caution, test carefully, and ensure alternate means of access prior to any deployment. As the author, I have no desire to assume any responsibility for a failed rotation, and its consequences. I especially disavow the “wipe” option below to remove entries from authorized_keys. It is presented as commentary, not working code. In any case, we foolishly rush in where the more prudent fear to tread. Read more

Amazon Linux 2022 Performs Well, But Intel's Clear Linux Continues Leading In The Cloud

AWS recently introduced Amazon Linux 2022 in preview form as the latest iteration of their Linux distribution now based on Fedora with various alterations to catering to their customers running it on EC2. Last week were benchmarks looking at Amazon Linux 2022 compared to Amazon Linux 2 and other distributions like CentOS and Ubuntu. In this article we are seeing how Amazon Linux 2022 can compete with Intel's own Clear Linux performance-optimized distribution. Read more

Games: Pokémon, Roundup, and Some More Titles on GNU/Linux

  • Bridging Game Worlds With The ‘Impossible’ Pokémon Trade | Hackaday

    Transferring hard-earned Pokémon out of the second generation GameBoy game worlds into the ‘Advance Era’ cartridges (and vice versa) has never been officially supported by Nintendo, however [Goppier] has made these illicit trades slightly easier for budding Pokémon trainers by way of a custom PCB and a healthy dose of reverse engineering. Changes to the data structure between Generation II on the original GameBoy (Pokémon Gold, Silver and Crystal) and Generation III on the GameBoy Advance (Pokémon Ruby, Sapphire, FireRed, LeafGreen and Emerald) meant that trades between these cartridges was never a possibility – at least not through any legitimate means. In contrast, Pokémon trades are possible between the first and second generation games, as well as from Generation III and beyond, leaving the leap from Gen II to Gen III as an obvious missing link.

  • Punk Wars, Axis & Allies 1942 Online, Melvor Idle, Unpacking … - itsfoss.net

    One more to liven up the December bridge, and that is that there is nothing more entertaining to pass the time than to play a game and that is partly Linux Play, our premiere native games section for Linux with this, its monthly edition with the best that came out in November. Including construction and survival title and Punk wars, the classic war strategy of Axis & Allies 1942 Online, the RPG hardcore Melvor idle… And a lot more, without forgetting the free title with which we close the list and that this time transfers the television phenomenon of The Squid Game to PC controls under the name of Crab Game. Linux Play!

  • NeuroNet: Mendax Proxy gets some first footage, mixing elements of Your Grace & Reigns | GamingOnLinux

    NeuroNet: Mendax Proxy is an upcoming adventure that the developer claims blends together elements found in the likes of Your Grace, Reigns and Astrologaster into something new. Set to launch in 2022, NeuroNet sees you take control of an AI charged with managing a city called Catena. You will need to make quick-fire decisions that impact the future and the prosperity of its citizens, with every choice and decision taken having a lasting effect on those you meet and the city's status. Lots of cyberpunk theming going on here with a new trailer giving a look into what to expect you can see below.

  • The Jackie and Daria update for Spiritfarer lands December 13 | GamingOnLinux

    The biggest update yet for the award-winning Spiritfarer lands on December 13, with plenty of new content. Spiritfarer is a casual thoughtful experience about being a ferrymaster for the deceased. You build up a boat, explore and care for various spirits before letting them go. With the new update coming the developer said it is the biggest yet with a new island to explore, there's two new spirits to make friends with and a hospital to bring back from the brink. On top of that there's also some sort of new platforming event and new upgrades for your ferry.

GNU/Linux on Desktop/Laptop Miscellany

  • What Is a Physical Kill Switch, and Does Your PC Need One?

    Purism is a company founded on the idea of having strict privacy and security features built into its computers. The Librem 14 is a prime example of this philosophy, and its hardware, firmware, and operating system have been designed with a significantly higher level of paranoia than typical computers. The Librem 14 Linux laptop features multiple physical kill switches, which the company claims absolutely disables the related hardware. There are switches for the webcam and microphone as well as WiFi and Bluetooth. When it comes to the Librem 14 in particular, there are so many additional privacy features that the kill switches really are the least of it, but there are examples of such kill switches in regular laptops that don’t go to such extremes. All the way back in 2018, HP was already shipping laptops with physical kill switches for the webcam. Their Specter laptops included these switches, so hopefully the chances of a hacked webcam recording you when you don’t want it to are virtually zero. Kill switches may not always take the form of a traditional sliding switch on the side of a laptop. It’s entirely possible to integrate the kill switch with a physical, built-in camera shutter.

  • Partaker Intel Core i3-8130U fanless mini PC Win 10 Linux supported $423

    Partaker have created a new fanless mini PC equipped with a wealth of connectivity and capable of supporting both the Microsoft Windows 10 and operating system most Linux distributions depending on your preference. Pricing starts from $423 for the Intel Core i3-8130U processor version although a more affordable Intel Celeron 3865u/3867u/3965u processor version is also available with prices starting from $246. Both are barebone systems meaning that you will need to provide your own memory, storage and operating system, enabling you to tailor the system to your exact requirements.

  • IGEL Releases Support for VMware Workspace ONE Intelligent Hub for Linux