All articles

PostgreSQL Conference Europe 2024 – Last day

As I reflect on my last day at PGConf.EU 2024 in the beautiful city of Athens, I am filled with a profound sense of gratitude and excitement. The conference was a melting pot of innovation, knowledge sharing, and community(…)

2024.pgconf.eu – Bigger than ever, the family is growing fast

The PostgreSQL community is growing every year and the same happens for pgconf.eu, which happened in Athens, Greece, this year. Attending this event is one of the best opportunities to get in touch with the people behind PostgreSQL. This(…)

PostgreSQL Conference Europe 2024 – Day 2

Here’s the following day 2 of the PostgreSQL Conference Europe 2024 in Athens, if you haven’t read the first day here is the link. After a fantastic first day, I was excited to dive into the next(…)

PostgreSQL Conference Europe 2024 – Day 1

Attending PostgreSQL Conference Europe 2024 in Athens is an incredible experience, full of enriching conversations and technical deep dives. As a DBA Consultant and speaker (on the reserve list and honored to have been chosen), it was my first(…)

M-Files Regional Partner 2024 (Geneva)

Last week, I had the pleasure to be invited to the M-Files Regional Partner in Geneva. M-Files people rallied around us: Tero Antila – Director EMEA Partner SalesHelinã Mellanen – Senior Enablement ManagerEmilie Feat – Senior Partner(…)

PostgreSQL 17: Enhancing JSON Support for Web Developers

PostgreSQL 17 introduces new features for working with JSON data. These features align PostgreSQL more closely with the SQL/JSON standard and improve the developer experience when dealing with semi-structured data. In this blog, we will explore the new JSON(…)

Improved not null/null planning in PostgreSQL 17

PostgreSQL 17 came with quite some additional features for the optimizer. One of them is about “is null” and “is not null” handling when column have a “not null” constraint defined. In the past it(…)

Creating a Global and Custom Snackbar in Vue 3 Using Vuetify and Pinia

In this post, we’ll walk through how to implement a Global and Custom Snackbar in Vue 3 with Vuetify and Pinia for state management. We’ll set it up so that you can easily trigger the Snackbar from any component(…)

Documentum – xPlore Dsearch not starting with a stuck rebuild

I recently faced another interesting issue (c.f. this one) with Documentum xPlore where the Dsearch would refuse to start because of a stuck online rebuild. It happened on a Kubernetes environment using custom images we(…)

PostgreSQL 18: Tweaking relation statistics

Up to now, there is no official way in PostgreSQL to tweak optimizer statistics manually. While this is quite common in other relational databases, PostgreSQL did not provide anything to do this. The first steps to allow this have(…)