Infrastructure at your Service

All Posts By

Karsten Lenz

Karsten Lenz

CentOS 8 alternatives

By | Operation systems | No Comments

Many people are unhappy about the decision from the CentOS Board of Directors, to switch from fix releases to Stream and cutting the support date from 2029 to 31st of December 2021 for CentOS 8. Many applications in productive environments require fix OS releases. Having more or less daily changing packages can cause many issues. People who have upgraded from CentOS 7 to 8 are in trouble again, the cut on the support date means,…

Read More
Karsten Lenz

Microsoft Flexible Server for PostgreSQL

By | Postgres | No Comments

This Blog is about some findings on Microsoft’s new Flexible Server offering for PostgreSQL which is in Customer Preview at the moment. Findings about the infrastructure The Microsoft Flexible Server for PostgreSQL is using Ubuntu as OS infrastructure, I think it is worth to be noticed that Microsoft’s new offering is switching from Windows to Linux. postgres=> select version(); version —————————————————————————————————————– PostgreSQL 12.5 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.12) 5.4.0 20160609, 64-bit Ubuntu upgrade…

Read More
Karsten Lenz

Azure Database for PostgreSQL

By | Database Administration & Monitoring | No Comments

This Blog is about some findings on Microsoft’s Azure service for PostgreSQL which I think needed to be noted. Findings about the infrastructure The Microsoft Azure Service for PostgreSQL is using Windows as OS Infrastructure, there are several points where it is possible to find out the used OS on PostgreSQL Level. select version(); => PostgreSQL 11.6, compiled by Visual C++ build 1800, 64-bi show dynamic_shared_memory_type; => windows show archive_command; => c:\postgres\bin\xlogcopy\xlogcopy.exe archive blob “%f”…

Read More
Karsten Lenz

The log_duration parameter in PostgreSQL

By | Database Administration & Monitoring | No Comments

log_duration is a useful point for finding slow running queries and to find performance issues also on the applications side using PostgreSQL as database. Another topic is finding issues with Java Applications using Hibernate after a migration to PostgreSQL. Often Hibernate switches from lazy to eager mode and this has massive impact on the application performance. In this context I will also describe one of the most useful extensions: pg_stat_statements. The log duration shown in…

Read More