PostgreSQL

PostgreSQL on Oracle free tier ARM

By Franck Pachot . This follows the previous post about the Oracle Cloud ARM compute shape just announced on May 25th. The processor is ARM v8.2 with LSE (atomic instructions) and PostgreSQL can benefit from it (see(…)

Why is the default postgres database slightly larger than template1?

You probably know that a fresh initialized PostgreSQL cluster comes with three databases by default: template0, template1, and postgres. If you want to know why they are there, and what their purpose is, check this post. In(…)

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

PostgreSQL, pg_ctl and signals

I believe most people use pg_ctl nowadays to start, stop, or restart a PostgreSQL instance. You can do all these tasks without using pg_ctl, but you'll notice in a minute that pg_ctl really is your friend. Even(…)

Getting started with Citus – Setting up a four node cluster

One issue with traditional database systems like PostgreSQL is, that you cannot easily scale vertically. Of course you could add read replicas and offload read operations, but that either requires changes in the application, or putting something in front that(…)

PostgreSQL: set_config and current_setting

PostgreSQL comes with a rich set of administrative functions for various use cases. There are functions to control parameters, there are functions for index maintenance, others are for recovery and or backup control and there is much more. In this(…)

Building a PostgreSQL EC2 AMI for testing the latest commits

Testing the latest features or bug fixes in PostgreSQL can easily be done by pulling the latest commits from the git repository and compile PostgreSQL from source code. I am doing that frequently on my local sandbox VM but this(…)

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

temBoard on SLES15 – 2 – The agent

In the last post we've installed the temBoard repository and the UI. As this alone is not so much fun, we'll be installing the temBoard agent on another SLES 15 machine in this post. We'll end up(…)

temBoard on SLES15 – 1 – The WebUI

During our last SwissPUG online meeting there was a presentation about monitoring PostgreSQL with temBoard. A question that came up afterwards was: How to install that on SLES 15 as there(…)