© Laurenz Albe 2025 If you ever get the error message “database is not accepting commands”, you are dangerously close […]
It's been a while since the last performance check of Transparent Data Encryption (TDE) in Cybertec's PGEE distribution - that […]
My trip to pgday.at started Wednesday at the airport in Düsseldorf. I was there on time, and the plane started […]
Introduction Recently, I read Laurenz Albe's blog about case insensitive string search. He recommended case insensitive collations, saying, "it won't […]
Introduction We have explored how to create cluster, take backups, connect to the cluster and run psql commands in our […]
I recently helped a customer with a slow query. Eventually, an ANALYZE on a partitioned table was enough to fix […]
Hyderabad: A City of Kings and Code Hyderabad has always been a city of stories. Once the capital of the […]
Introduction In our CNPG series, we have explained how to create a PostgreSQL cluster and how to customize it. However, […]
I first came across the butterfly effect during college. You have probably heard of it, the idea that a butterfly […]
© 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. […]
