Daniel Westermann

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(…)

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(…)

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(…)

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(…)

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(…)

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(…)

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(…)

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(…)

Creating your private cloud using OpenStack – (2) – Preparing the nodes

In the introduction post we’ve briefly looked at some options you have available when you want to build your own private cloud. In this post we’re going to start our journey into OpenStack by preparing(…)

Creating your private cloud using OpenStack – (1) – Introduction

While public clouds are a trend since several years now, some companies are also looking into self hosted solutions to build a private cloud. Some do this because of costs, others do this because they don’t want to be(…)