Laurenz Albe

Senior Consultant & Support Engineer

Laurenz Albe is a senior consultant and support engineer at CYBERTEC. He has been working with and contributing to PostgreSQL since 2006, has written patches for core, and wrote oracle_fdw. He holds a Master's degree in Mathematics from the University of Vienna and a Master's in Computer Science from the Technical University of Vienna. In his spare time he enjoys reading to his children and pondering the roots of language.

Articles by Laurenz Albe

Syslog logging with journald in PostgreSQL

by Laurenz Albe | 04.2024

Logging to syslog is not a new PostgreSQL feature at all. Still, I find few people using it, so perhaps […]

How To

PostgreSQL parallel query problems in JDBC and DBeaver

by Laurenz Albe | 01.2024

I recently investigated a surprising behavior of the DBeaver database client in connection with PostgreSQL parallel query, which I'd […]

How To

Broken foreign keys: how can that happen in PostgreSQL?

by Laurenz Albe | 12.2023

One of the fundamental requirements for a relational database is that the transaction system always maintains consistency. That means […]

How To

What you should know about PostgreSQL minor upgrades

by Laurenz Albe | 12.2023

How To

PostgreSQL hash index performance

by Laurenz Albe | 12.2023

Among the many index types in PostgreSQL, the hash index is the most widely ignored. This came home to […]

Performance

Conditional foreign keys and polymorphism in SQL: 4 Methods

by Laurenz Albe | 08.2023

This article is about the notoriously difficult problem of “conditional foreign keys”. In object-oriented programming languages, polymorphism is a […]

How To