Daniel Westermann

Configuring huge pages for your PostgreSQL instance, Debian version

In the last post we had a look at how you can configure huge pages on RedHat and CentOS systems. For Debian and Debian based systems the procedure is different as Debian does not come with(…)

Configuring huge pages for your PostgreSQL instance, RedHat/CentOS version

Almost every PostgreSQL I get in touch with is not configured to use huge pages, which is quite a surprise as it can give you a performance boost. Actually it is not the PostgreSQL instance you need(…)

New SHA-2 functions showing up in PostgreSQL 11

A recent commit announced new SHA-2 functions coming up in PostgreSQL 11. Until now you can use the md5 function to generate hashes for test data or whatever you want. This commit adds more(…)

My personal journey with Linux on the desktop

My Linux experience started back in 1999 when we needed a router for our ISDN connection in our shared apartment when we were students. I don't remember the hardware we used for that but I am sure at(…)

What you can do when your Veritas cluster shows interfaces as down

Recently we had the situation that the Veritas cluster (InfoScale 7.3) showed interfaces as down on the two RedHat 7.3 nodes. This e.g. can happen when you change hardware. Although all service groups were up and running this is a(…)

How we build our customized PostgreSQL Docker image

Docker becomes more and more popular these days and a lot of companies start to really use it. At one project we decided to build our own customized Docker image instead of using the official PostgreSQL one.

Does pg_upgrade in check mode raises a failure when the old cluster is running?

Today I had the pleasure to have Bruce Momjian in my session about PostgreSQL Upgrade Best Practices at the IT Tage 2017 in Frankfurt. While browsing through the various options you(…)

No journal messages available before the last reboot of your CentOS/RHEL system?

As you probably noticed RedHat as well as CentOS switched to systemd with version 7 of their operating system release. This also means that instead of looking at /var/log/messages you are supposed to use(…)

Are statistics immediately available after creating a table or an index in PostgreSQL?

While giving the last PostgreSQL DBA Essentials workshop this question came up: When we create a table or an index: are the statistics available automatically? To be more precise: When we create and load a table in(…)

Create index CONCURRENTLY in PostgreSQL

In PostgreSQL when you create an index on a table, sessions that want to write to the table must wait until the index build completed by default. There is a way around that, though, and in this post we'll look(…)