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 […]
Learn how to combine the usage of regular expressions and arrays in PostgreSQL into a more powerful technology through this blog post.
© Laurenz Albe 2025 Recently, I wrote about the power of open source. Now, power is good and important, but […]
Migrate to PostgreSQL fast, furious, and FREE: get the CYBERTEC Migrator Standard Edition, the fastest free migration tool!
How do PostgreSQL's VACUUM optimizations affect dead tuple metrics? Find out why they might persist or reappear when using VACUUM.
Pre-Conference Travels: Debian & Berlin The week before this year's PGConf.DE, I attended the Debian MiniDebConf in Hamburg. Adding Berlin […]
From insightful talks and customer meetings to the big launch of the Open Alliance for PostgreSQL Education (OAPE), we came […]
Data types play a crucial role in ensuring optimal performance, efficiency, as well as semantics. Read more about CREATE INDEX.
