© Laurenz Albe 2025 People often ask “How can I automatically rebuild by indexes regularly?” or “When should I rebuild […]
Introduction The importance of backups is universally acknowledged in our digital world. One of my former esteemed colleagues told me […]
Motivation The extension btree_gist lives in PostgreSQL contrib and implements btree-like operators and behavior on top of the GiST framework. […]
It's Sunday and I'm now sitting in the train from Brest to Paris where I will be changing to Germany, […]
Introduction In our previous blog, we have done an introduction to CloudNativePG (CNPG) and showed how we can create a […]
© Laurenz Albe 2025 You may have encountered the abbreviation PGDG or the long version “PostgreSQL Global Development Group” in […]
Storing and archiving data efficiently When it comes to designing and optimizing databases, one of the most critical aspects is […]
Introduction The cloud has become an undeniably crucial part of our lives. It's pretty much everywhere across the entire IT […]
This year I was happy to join the Swiss PGDay in Rapperswil Switzerland on the 26th and 27th of June! […]
As the Design Lead at CYBERTEC, a company deeply involved in the PostgreSQL community, I have the privilege of contributing […]
© Laurenz Albe 2025 Everybody wants good performance. When it comes to the execution of SQL statements, accurate optimizer statistics […]
© Laurenz Albe 2025 Recently, while investigating a deadlock for a customer, I was again reminded how harmful SELECT FOR […]
