PostgreSQL 12.0 is available

Windows Articles

How to create GPO in Windows Server 2019.

Hi, in today's post we will be looking at GPOs in Windows Server 2019. The Group Police Object are a set of...

How to install OpenLiteSpeed on Ubuntu 20.04?

There are several web servers for Linux but other alternatives are always welcome. In this case, I will show you how to...

Linux 5.7 available

Time passes very quickly and we already have a new version of the Linux kernel that as always we are happy because...

How to install RStudio on Ubuntu 20.04 / 18.04

No matter how complete and robust a programming language is, the programmer will always need a tool to write the code. These programs have...

How to install Arduino IDE on Ubuntu 20.04 / 18.04 / Linux Mint 19.X?

Hi, folks. In this post, we will show you how to install Arduino IDE on Ubuntu 20.04/ 18.04 and Linux mint 19.x. You probably already...
angeloma
angeloma
Senior Writer and partner

Recently the PostgreSQL development team announced the release of version 12 of the program. PostgreSQL is perhaps one of the most popular relational database management systems out there and this is relevant news in the server world. Besides this, it is good to say that every day these applications improve to adapt to new circumstances. Therefore, today we are going to talk about PostgreSQL 12.

PostgreSQL 12 some features

PostgreSQL 12 is already a veteran database management system. It already has a 20-year history and is considered by many to be the most advanced database manager out there. It is an open-source value because its code is available to everyone.

Likewise, PostgreSQL competes directly with other proprietary solutions such as Oracle, SQL Server, and IBM DB2. And they have surprised us with this new version.

In short, PostgreSQL 12 has many improvements. Some of them are the following:

  • How common table expressions (WITH) are executed has been optimized. As well as the generated columns.
  • Now programmers will benefit because there is support for the expression of SQL/JSON paths. This feature has been done recently in MySQL.
  • In this new version of PostgreSQL takes a good leap in performance. First, it better manages the space required in large databases. Second, the execution times of the queries. Vital.
  • A feature has also been added that allows developers to define their own data storage methods.

So, as we can see in the improvements, it is an important version that helps to add little by little to a great application. Incidentally, it has the sponsorship of large companies worldwide that see in PostgreSQL an important program within their organizations.

By way of conclusion, we can say that PostgreSQL 12 is a major version that adds stability and important features to an already important application. It only remains to wait for the official repositories to include the updated packages so that they can be easily installed in the main Linux distributions.

So, share this post with your friends. Also, join our Telegram Channel.

More articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest article

How to create GPO in Windows Server 2019.

Hi, in today's post we will be looking at GPOs in Windows Server 2019. The Group Police Object are a set of...

How to install OpenLiteSpeed on Ubuntu 20.04?

There are several web servers for Linux but other alternatives are always welcome. In this case, I will show you how to...

Linux 5.7 available

Time passes very quickly and we already have a new version of the Linux kernel that as always we are happy because...

How to install RStudio on Ubuntu 20.04 / 18.04

No matter how complete and robust a programming language is, the programmer will always need a tool to write the code. These programs have...

How to install Arduino IDE on Ubuntu 20.04 / 18.04 / Linux Mint 19.X?

Hi, folks. In this post, we will show you how to install Arduino IDE on Ubuntu 20.04/ 18.04 and Linux mint 19.x. You probably already...