Open source Team

De-Ubuntu Ubuntu

Canonical is consistently promoting Snap Integration in the Ubuntu world with all its market power. However, many do not like this development with Ubuntu. But what options do you still have as an Ubuntu user if you don’t necessarily want(…)

Rancher installation on RHEL 8 compatible Linux

This Blog is about the installation of Rancher Community on a RHEL 8 compatible Linux, for this Blog i choose AlmaLinux 8.4, but i will also work on Rocky Linux 8.4 Release Candidate. Base is an AlmaLinux / Rocky(…)

PostgreSQL on AWS Graviton2: CFLAGS

By Franck Pachot . In a previous post I’ve compiled PostgreSQL with GCC 7 and GCC 11 with the default options and checked that the ARM v8.2 features were used. However it may not be so simple:(…)

CentOS 8 binary compatible alternatives

There is a lot of roumors around since it was anounced to switch CentOS 8 from a Downstream Build from RHEL 8 to a Upstream Build for RHEL 8 on December 8th 2020. Many people asked why a second(…)

Pass a variable to a trigger in PostgreSQL

By Franck Pachot . With Oracle there are many ways to set a state in the session: context variables, set with DBMS_SESSION.SET_CONTEXT and retrieved with SYS_CONTEXT, or package global variables, or global or private temporary tables with ON COMMIT(…)

K8s on Windows/VirtualBox

By Franck Pachot . This is a little demo, easy to copy-paste, if you want to play with Kubernetes on your laptop. And, not a simple “Hello World” but a real database running here, able to scale up and(…)

Working with multipass, a VM manager

Introduction What if you need quickly to launch virtual machine instances running Ubuntu for development and testing purposes. Multipass from Canonical can be the right tool for this. You can even customize the instances during launch by using Cloud-init in(…)

Should CPU-intensive logic be done in the DB or in application server?

By Franck Pachot . Should CPU-intensive logic be done in the DB or in application server? Here was a answer found in Reddit: Comment byu/CacheMeUp from discussion inPostgreSQL Reducing the(…)

Linux perf-top basics: understand the %

By Franck Pachot . Linux kernel has a powerful instrumentation that can be accessed easily. When you want to drill down into your program functions to understand their CPU usage, “perf” is the easiest. It can attach to the(…)

AWS: PostgreSQL on Graviton2 with newer GCC

By Franck Pachot . In the previous post I have run PostgreSQL on AWS m6gd.2xlarge (ARM Graviton2 processor). I didn’t precise the compilation option and this post will give more details following this feedback:(…)