Skip to content

Database

Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.

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(). Beside the pg_stat_checkpointer view, the statistics in pg_stat_bgwriter, pg_stat_io, pg_stat_wal, pg_stat_recovery_prefetch, and pg_stat_archiver can be reset. Before PostgreSQL 17 you had to call this function individually for all… 

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 to split the statistics related to those background processes as well. This has now happened for PostgreSQL 17. Up to PostgreSQL 16 the pg_stat_bgwriter… 

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 setup was GUI driven and almost nothing had to be done manually, except for the creation of a user and configuration of pg_hba.conf. Currently we have the primary replicating to the replica… 

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 limit I am talking about is the maximum number of columns which can be in a table. In the documentation you’ll find this: “The maximum number of columns… 

Redis: Redis X Grafana fix the “get instance error” message

Introduction Last time, we have seen how to add a Redis plugin to Grafana in order to monitor and generate graphs and charts for your reports or analysis. During this configuration you may encounter some issues or miss some steps that will end to an error message. Today we will see some typical error message and who to fix it… 

APEX/ORDS 23.x – DispatcherNotFoundException

The aim of that blog is to look into Oracle REST Data Services (ORDS) 23.x error raised when setting up for APEX 23.1. This is following some experience at a customer who wanted to move to latest version of ORDS with APEX 23.1, in late 2023, and ran into an issue. If you have encountered similar error as below, when… 

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. At the end of this post we should have a primary PostgreSQL instance replicating to a replica, and this configuration is managed by DBVISIT StandbyMP. This is the… 

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 cluster. In this post we’re going to set this up, and in a follow up post we’ll see how this product can be used to easily switchover to… 

Redis:Connect a Redis plugin to Grafana

Introduction: Monitoring our Redis database is one of the first thing we want to do : Checking the database status , the queries consumption and also make a report on it. For that, we will use Grafana: It is an open source analytics & monitoring solution for every database. Grafana can add some plugins to work on a specific database.I…