Deploying and Managing PostgreSQL 11: New in ClusterControl 1.7.1
A few days ago was the release of a new version of ClusterControl, the 1.7.1, where we can see several new features, one of the main ones being the support for PostgreSQL 11. To install...
Announcing ClusterControl 1.7.1: Support for PostgreSQL 11 and MongoDB 4.0, Enhanced Monitoring
We are excited to announce the 1.7.1 release of ClusterControl - the only management system you’ll ever need to take control of your open source database infrastructure! ClusterControl 1.7.1 introduces the next iteration of our agent-based...
An Overview of Just-in-Time Compilation (JIT) for PostgreSQL
Historically PostgreSQL has provided compilation features in the form of ahead-of-time compilation for PL/pgSQL functions and version 10 introduced expression compilation. None of those generate machine code though. JIT for SQL was discussed many years...
PostgreSQL Replication for Disaster Recovery
With Disaster Recovery, we aim to set up systems to handle anything that could go wrong with our database. What happens if the database crashes? What if a developer accidently truncates a table? What if...
PostgreSQL on the Rise: 2018 Postgres Findings & 2019 Trends
A strong community coupled with an increasingly stable and feature-rich platform are making PostgreSQL a strong contender for replacing the “big boys” of enterprise data. We here at Severalnines have also seen this trend and...
Webinar Replay: How to Manage Replication Failover Processes for MySQL, MariaDB & PostgreSQL
If you’re looking at minimizing downtime and meet your SLAs through an automated or semi-automated approach, then this webinar replay is for you: A detailed overview of what failover processes may look like in MySQL,...
Using PostgreSQL Logical Replication to Maintain an Always Up-to-Date Read/Write TEST Server
In this blog entry we’ll talk about logical replication in PostgreSQL: its use cases, general information on the status of this technology, and a special use case in particular on how to setup a subscriber...
How to Take Advantage of the New Partitioning Features in PostgreSQL 11
What is Partitioning? Partitioning splits large tables into smaller pieces, which helps with increasing query performance, making maintenance tasks easier, improving the efficiency of data archival, and faster database backups. You can read more...
How to Upgrade PostgreSQL10 to PostgreSQL11 With Zero Downtime
Historically, the hardest task when working with PostgreSQL has been dealing with the upgrades. The most intuitive upgrade way you can think of is to generate a replica in a new version and perform a...
An Overview of the New Stored Procedures in PostgreSQL 11
As you may know in all the versions up to PostgreSQL 10, it was not possible to create a procedure in PostgreSQL. In PostgreSQL 11, PROCEDURE was added as a new schema object which is...
What's New in PostgreSQL 11
PostgreSQL 11 was released on October 10th, 2018, and on schedule, marking the 23rd anniversary of the increasingly popular open source database. While a complete list of changes is available in the usual Release Notes,...
Ten Ways to Expand the Functionality of PostgreSQL
As you may know, you can extend PostgreSQL functionality by using PostgreSQL extensions. You can use different extensions to make PostgreSQL like an enterprise version and address specific needs. In this blog, we'll see some...