All articles

PostgreSQL: Indexes and casting

This is a small reminder to be careful with casting one data type to another in your queries when you want to have an index access rather than a sequential scan. Here is a small example of what can happen:(…)

PostgreSQL 18: Per-relation cumulative statistics for [auto]vacuum and [auto]analyze

This is about another feature which will most likely show up in PostgreSQL 18 later this year. The statistic system is something which gets more and more details with almost every release of PostgreSQL, and PostgreSQL 18 will be no(…)

Managing multilingual documents including version control

Business requirements Manage version controlled documents The documents must be available in different languages Each document has his own initial language version The translated documents must be in relationship with the initial document Should a document version be subject to(…)

Issue with external connector in M-Files Server 25.1 (January 2025)

Problem defintion I encountered an issue with the configuration of an external connector in the M-Files Server 25.1 (January 2025). In my case, this was the M-Files Network Folder Connector. The installation of the Vault Application proceeded smoothly, as usual.

How to clone remote PDB with dbaascli on ExaCC?

When your DB infrastructure move to ExaCC, it’s a good option to appropriate the tools offer by it to facilitate your life. And for ExaCC, this tool is dbaascli. It manages many aspects of the ExaCC layers. And in this(…)

Creating your private cloud using OpenStack – (7) – Horizon, the OpenStack dashboard

We’ve finished the last post with a working Network (Neutron) service on the controller and compute node. In this post we’ll setup the final service which is Horizon, the OpenStack dashboard. Once more, looking back at(…)

L’historisation des données

L’historisation des données, processus clé d’un projet BI, consiste à conserver et gérer différentes versions des données pour permettre l’analyse historique, la traçabilité et le suivi des tendances. 1 – Pourquoi historiser ? L’historisation répond à des questions clés : Quelle était(…)

Creating your private cloud using OpenStack – (6) – The Networking service

We’ve finished the last post with a working Compute (Nova) service on the controller and compute node. While only the compute(s) actually run compute resources, Nova is also running on the controller for the management tasks, while libvirt is only(…)

Creating your private cloud using OpenStack – (5) – The Compute service

We’re now coming closer to the final setup of the OpenStack test environment. Again, looking at the minimum services we need, there are only three of them left: Keystone: Identity service (done)(…)

PostgreSQL 18: Add OLD/NEW support to RETURNING in DML queries

While doing some research on OpenStack (see here for the introduction post), I thought blogging about a new feature for the next version of PostgreSQL might free my head a bit from(…)