Daniel Westermann

PostgreSQL 18: Virtual generated columns

This is about another feature which was committed for PostgreSQL 18: Virtual generated columns. Generated columns are available already, but they need to be “STORED”. This means the result of an expression is stored to disk and the result is(…)

PostgreSQL 18: Introduce autovacuum_vacuum_max_threshold

Vacuum/Autovacuum is one of the critical parts of every PostgreSQL installation. When autovacuum is not configured properly for your workload you’ll suffer from bloat and performance issues sooner or later. Most of the installations we’ve seen run with(…)

PostgreSQL: Indexes and casting

This is a small reminder to be careful with casting one data type to another in your queries when you want to have an index access rather than a sequential scan. Here is a small example of what can happen:(…)

PostgreSQL 18: Per-relation cumulative statistics for [auto]vacuum and [auto]analyze

This is about another feature which will most likely show up in PostgreSQL 18 later this year. The statistic system is something which gets more and more details with almost every release of PostgreSQL, and PostgreSQL 18 will be no(…)

Creating your private cloud using OpenStack – (7) – Horizon, the OpenStack dashboard

We’ve finished the last post with a working Network (Neutron) service on the controller and compute node. In this post we’ll setup the final service which is Horizon, the OpenStack dashboard. Once more, looking back at(…)

Creating your private cloud using OpenStack – (6) – The Networking service

We’ve finished the last post with a working Compute (Nova) service on the controller and compute node. While only the compute(s) actually run compute resources, Nova is also running on the controller for the management tasks, while libvirt is only(…)

Creating your private cloud using OpenStack – (5) – The Compute service

We’re now coming closer to the final setup of the OpenStack test environment. Again, looking at the minimum services we need, there are only three of them left: Keystone: Identity service (done)(…)

PostgreSQL 18: Add OLD/NEW support to RETURNING in DML queries

While doing some research on OpenStack (see here for the introduction post), I thought blogging about a new feature for the next version of PostgreSQL might free my head a bit from(…)

Creating your private cloud using OpenStack – (4) – The Image and Placement services

By the end of the last post we finally got the first OpenStack service up and running: Keystone, the Identity Service. Going back to the list of services we need at a(…)

Creating your private cloud using OpenStack – (3) – Keystone, the Identity Service

By the end of the last post, we finished with preparing the controller and compute node for being ready to deploy the first OpenStack service: Keystone, the Identity Service. Before we dive into the details lets(…)