The PostgreSQL database server is written in the programming language C. This article describes how dynamic memory is handled in the PostgreSQL database server. In contrast to plain C programs, MemoryContexts are used.
The PostgreSQL database server contains many Assert statements in its code. These statements are additional checks that can be evaluated to ensure that the performed operations are executeed as expecteed. However, evaluating of these statements takes some CPU time. Therefore, they are disabled in most production environments.
Kubernetes is one of the most popular container orchestrators these days. In this post, it is shown how the software can be installed on bare-metal servers or virtual servers by using kubeadm and Ansible.
In the 1990s and early 2000s, the Concurrent Versions System (CVS) was one of the most popular systems to manage source code repositories. However, the software was replaced by Subversion (SVN) in the middle of the 2000s. The development of the original CVS implementation was ended in 2008. Since around 2010, git is one of the most popular systems in this field. This article deals with the challenge of migrating a legacy CVS repository to git in the year 2022.
The OpenStreepMap project provides their database for download. This is called the OSM planet dataset, which has a size of several gigabytes and contains the spatial data (e.g., roads, forests, buildings) of the whole world. The dataset is encoded in different data formats (e.g., XML or OpenStreetMap Protocolbuffer Binary Format). To be able to import the dataset into systems that are capable of handling spatial data, the data needs to be converted into GeoJSON.