13 September 2019
Yesterday, the fourth beta of the upcoming PostgreSQL major version 12 was released. Compared to its predecessor PostgreSQL 11, there are many new features: Performance improvements for indexes: btree indexes now manage space more efficiently. The REINDEX command now also supports CONCURRENTLY, which was previously only possible with new indexes. WITH queries are now embedded […]
23 April 2019
One would think that microcode updates are basically unproblematic on modern Linux distributions. This is fundamentally correct. Nevertheless, there are always edge cases in which distribution developers may have missed something. Using the example of Ubuntu 18.04 LTS “Bionic Beaver” in connection with the XEN Hypervisor this becomes obvious when it comes to processors microcode […]
02 April 2019
Today it is no longer necessary to argue why central logging makes sense or is even necessary. Most medium-sized companies now have a central logging system or are just introducing it. Once the infrastructure has been created, it must be used sensibly and efficiently! Especially as an infrastructure operator or service provider it is important […]
21 March 2019
Lately, with the rise of extensive container orchestration and microservices, Kubernetes has been getting more and more exposure and has become the de facto standard for orchestration in these environments. In this context, orchestration of PostgreSQL clusters with the help of Kubernetes has been a more recent development that can improve availability and reduce operational […]
13 March 2019
Patroni is a PostgreSQL high availability solution with a focus on containers and Kubernetes. Until recently, the available Debian packages had to be configured manually and did not integrate well with the rest of the distribution. For the upcoming Debian 10 “Buster” release, the Patroni packages have been integrated into Debian’s standard PostgreSQL framework by […]