Database management

Generated columns in PostgreSQL

Sometimes it becomes handy when you can auto-generate a column based on an expression. For this there is the concept of generated column. Those columns can be either of type “stored” (the derived value is computed when the column(…)

PostgreSQL: System catalog modifications are currently disallowed

Today at a customer I faced this: “System catalog modifications are currently disallowed” which, honestly, I’ve never seen before. Why would someone try to modify the system catalogs, at least in a productive environment? It turned out to be(…)

SQL Server Tips: CMS – Connection Error: -2146893019 Severity: 20

Few days ago, I install new instances SQL Server 2022 and the new SSMS by a customer and when I register the instances in the Central Management Servers (CMS), I was surprise by the error coming from the connection(…)

PostgreSQL 16: More statistics in pg_stat_*_tables

PostgreSQL 16 is already in feature freeze and Beta1 has been released on May 25th. This is the time you should start testing and report any issues back to the community. There are plenty of new features, as usual,(…)

2023.pgconf.de and the Swiss PGDay are just around the corner

Time flies, we are in June already and at the end of this month two PostgreSQL conferences will take place: There is 2023.pgconf.de, this year in Essen, the 27th of June. For the first time(…)

MariaDB manual Switchover

I’m going to explain how to do a manual Switchover in a MariaDB HA setups using master-slave replication. In my example, let’s consider that I’ve a server01 and server02, both running on Ubuntu 20.04. server02 is currently(…)

How a merge join produced the wrong result in PostgreSQL

This was a really interesting customer case and I learned a lot by troubleshooting this. The original request was: We have two databases connected via postgres_fdw and when a merge join is chosen by PostgreSQL(…)

PostgreSQL 16: GENERIC_PLAN option for EXPLAIN and SHELL exit codes for psql

Last week some smaller features got committed for PostgreSQL. The first one is an option which can be given to explain for displaying the generic plan for a statement. I’ve written about generic plans in the past, please read(…)

pgDay Paris 2023

Another great PostgreSQL community conference is over, and I came back with a lot of impressions yesterday. It was probably the worst time of the year for the conference to happen, as massive strikes are ongoing in France currently.

Microsoft Flexible Server Compute V5

Today I had the chance to move forwar with performance testing and some checks on two Flexible Server – Azure Database for PostgreSQL, one with 8vCPU, 64GB RAM and 512GB Storage (2300 IOPs) and another one with the same(…)