PostgreSQL is one of the most popular and advanced relational database management systems. Because of its…
PostgreSQL is one of the most popular and advanced relational database management systems. Because of its capabilities, it has been appreciated by the webmaster community around the world for years. CloudHosting service users can, as of today, use its latest version, PostgreSQL 16. Release 16 is a collection of further improvements and new features, thanks to which the performance of databases, their security and the stability of application operation have been improved.
New features in PostgreSQL 16
PostgreSQL 16 is a new branch of this database system with updates scheduled until November 2028. The introduction of PostgreSQL 16 also marks the end of the development of version 11, which will soon lose the support of the developers of this software.
PostgreSQL 16 introduces enhancements that significantly improve database performance. The logical replication mechanism has been improved with control tools. Among other things, the pg_create_subscription function has been introduced, allowing to grant permissions to create new subscriptions. An important improvement is also the ability to perform logical replication from physical replication instances, which allows streaming data to the database. This provides developers with more freedom when distributing load.
The new version introduces changes in permission management. In PostgreSQL 16, they no longer have to rely solely on super-user accounts. This improves the security of databases through improved user roles and permissions. PostgeSQL 16 also means better efficiency in memory management. The publishers of this database have…