Database Administration & Monitoring

PostgreSQL 17: Incremental backups and backup chains

In the last post about the introduction of incremental backups for PostgreSQL 17 we’ve looked at the basic concepts of that feature and how you can use it. In the meantime Robert(…)

PostgreSQL 17: Support for incremental backups

When it comes to backing up and and restoring a PostgreSQL cluster, most of our customers rely either on pgBackRest or Barman. The reason for this is pretty clear: Both of those(…)

pgconf.eu 2023 – First participation

I am thrilled to share that I had the opportunity to attend the 13th Annual PostgreSQL Conference Europe in Prague which took place between the 12th and the 15th of December. It was my first participation(…)

2023.pgconf.eu – recap

This year’s edition of PostgreSQL Conference Europe finished last Friday, the 15th of December. It was the largest ever PostgreSQL Conference Europe with more than 700 attendees. For me the week already started on Monday, because(…)

PosgreSQL + SQL Server = WiltonDB – Part 1 – Installation

I know,  few years ago, it was uncredible to associate SQL Server & PostgreSQL or see Microsoft in the Open source world. 😉 The world changes and we follow it… My colleague Daniel Westermann will enjoy that I write(…)

Boost dynamic SQL with Plan Guides

Recently a customer asked me to check why a load process from a banking application has so poor performance.In fact this process is extremely slow, between 40 minutes up to more than one hour to load around 240’000 rows. As(…)

SQL Server Integrated acceleration & offloading

Introduction I was asked by one of my customers to have a look at the SQL Server 2022 Integrated acceleration & offloading feature. The goal of it is to provide a framework for offloading specific SQL Server workload compute to(…)

Monitor Microsoft SQL Server with Zabbix

In this blog post, we will quickly see what is required to monitor a Microsoft SQL Server with Zabbix. Agent Setup Agent setup is not required by MSSQL by ODBC template; thus this step can be skipped. Setup Monitoring Account(…)

PostgreSQL 17: Reset shared statistics at once with pg_stat_reset_shared()

PostgreSQL comes with several catalog views which expose cluster wide statistics. One of them is the new pg_stats_checkpointer view we’ve talked about previously. To reset some of those statistics there is pg_stat_reset_shared().

PostgreSQL 17: New catalog view pg_stat_checkpointer

Up to PostgreSQL 16 checkpointer related statistics are available in pg_stat_bgwriter. As the work of bgwriter and checkpointer has been split into two separate processes back in 2011 for PostgreSQL 9.2 (see 806a2aee3791), it makes sense(…)