All articles

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

Cloudbees CD/RO, Pipelines advanced parameters

Cloudbees CD/RO is a highly flexible tool. You can define your own customized parameter forms for pipelines or procedures.For example, the same parameter form can be adapted according to the users: user-friendly for common users or more permissive for admin(…)

Alfresco – Use Alfresco for a Trivia Game – Play the game

In previous blogs (here & here), I talked about the Repository skeleton necessary and then about how to use REST-API to add questions and answers into Alfresco for the Trivia Game. In(…)

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

Alfresco – Use Alfresco for a Trivia Game – Add questions

In a previous blog, I talked about using Alfresco to setup a simple Trivia Game and more specifically the Repository part of it, i.e., the meta-model and the structure I will use. In this second part,(…)

Alfresco – Use Alfresco for a Trivia Game – Repository skeleton

Have you ever wondered how you could use Alfresco to run a Trivia Game? No? Strange, I believe that should be a very important question to ask yourself when you are looking for an ECM for your company! If you(…)

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

Documentum – xPlore CPS unreachable and not starting

During an upgrade project of xPlore from 16.4 to 20.2 at a customer, I faced a quite interesting issue with the xPlore CPS (Content Processing Services) that couldn’t start properly and were, therefore, shown as “UNREACHABLE“. The funny thing is(…)

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