Database Administration & Monitoring

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

DBVISIT StandbyMP for PostgreSQL – 3 – Switchovers

In the last two posts (here and here) we’ve installed and configured DBVISIT StandbyMP for PostgreSQL and created a simple primary -> replica setup. Most of the replication(…)

What is the maximum number of columns for a table in PostgreSQL?

In our PostgreSQL DBA Essentials workshop we’re also letting the attendees know about the limits of PostgreSQL. Those limits are documented but one of those limits might not be very clear. The(…)

DBVISIT StandbyMP for PostgreSQL – 2 – Creating a PostgreSQL configuration

In the previous post we’ve installed the DBVISIT StandbyMP agents on the database nodes, and the management console on third node. In this post we’re going to create our first PostgreSQL configuration.

DBVISIT StandbyMP for PostgreSQL – 1 – Setting it up

One of our oldest partners, DBVISIT, recently released their product StandbyMP for PostgreSQL. The goal of this product is to provide a graphical user and management interface over a PostgreSQL streaming replication(…)

Locales, collations, encodings and the PostgreSQL sort order (2) – sorting strings

In the last post we’ve looked at how you can tell initdb which character set and locale it should use for the initial databases. In this post we’ll look at how you(…)