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

LibreOffice Base Guide 7.2 has been released

The LibreOffice Documentation Team releases the Base Guide 7.2, based on refactored content from the Base Guide 6.4, with the 7.2 branding and text layout. It covers LibreOffice’s database component. The team decided to just fast-forward the release number, given the very little developments for Base since LibreOffice 6.4. The team intended to complete the Guide set for LibreOffice 7.2 and get ready to update contents of the set for the forthcoming LibreOffice 7.3 release. The LibreOffice Base Guide is a community effort that include valuable collaboration from Robert Großkopf, Pulkit Krishna, Dan Lewis, Drew Jensen (In Memoriam), Peter Schofield, Jost Lange, Steve Schwettman, Jean-Pierre Ledure, Jochen Schiffers, Martin Fox, Alain Romedenne, Jenna Sargent, Hazel Russman, Andrew Pitonyak and Randolph Gamo. Read more

Krita 4 splash screen

This easter egg is not part (yet) of Krita 5, will not be part of the release of 5.0 coming soon and that's good: you don't want to miss the new splash screen from Tyson Tan with the larger size in Krita 5. It's splendid! But for sure I'll try to propose an illustration for later Krita 5.1 or 5.2 release, one that could be ready before December 2022. Feel free to also contribute to make ones (it's not just a privilege I had), you just need to propose your artwork made with Krita, with an aspect ratio for this format, about the season, and with a permissive license (eg. CC-By 4.0). Don't forger to post-it on https://krita-artists.org/ , so the community and developers can see it. Read more

LoRa expansion boards work with Raspberry Pi SBC and Raspberry Pi Pico board (Crowdfunding)

We’ve covered a number of LoRa solutions based on Raspberry Pi boards, and SB Components is now offering another with the LoRa HAT for Raspberry Pi equipped with an Ebyte E22 LoRa module operating in either the 433 MHz, or 868 and 915 MHz bands. The company also offers a LoRa expansion for Pico based on the same E22 module, adding a small 1.14-inch LCD for information display, and designed for the Raspberry Pi Pico board with the RP2040 dual-core Cortex-M0+ microcontroller. Read more

Programming Leftovers