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

Never lose a PostgreSQL transaction with pg_receivewal

by Laurenz Albe | 10.2019

“Durability”, the D of ACID, demands that a committed database transaction remains committed, no matter what. For normal […]

How To

Manage Linux control groups in PostgreSQL with pg_cgroups

by Laurenz Albe | 09.2019

(This article and the extension pg_cgroups was written for cgroups v1. The extension won't work with cgroups v2, but the […]

How To

Tracking view dependencies in PostgreSQL

by Laurenz Albe | 09.2019

We all know that in PostgreSQL we cannot drop an object if there are view dependencies on it: [crayon-6649658fdef26629924351/] […]

How To

ICU collations against PostgreSQL data corruption

by Laurenz Albe | 07.2019

(Updated 2023-07-18) This article was prompted by version 2.28 of the GNU C library, which changed the definition of […]

How To

Abusing SECURITY DEFINER functions in PostgreSQL

by Laurenz Albe | 05.2019

UPDATED August 2023: Functions defined as SECURITY DEFINER are a powerful, but dangerous tool in PostgreSQL. The documentation warns of […]

How To

PostgreSQL v12 new feature: optimizer support for functions

by Laurenz Albe | 05.2019

PostgreSQL commit 74dfe58a5927b22c744b29534e67bfdd203ac028 has added “support functions”. This exciting new functionality that allows the optimizer some insight into functions. […]

News

Triggers to enforce constraints in PostgreSQL

by Laurenz Albe | 04.2019

Sometimes you want to enforce a condition on a table that cannot be implemented by a constraint. In such […]

How To

PostgreSQL count(*) made fast

by Laurenz Albe | 04.2019

It is a frequent complaint that count(*) is so slow on PostgreSQL. In this article I want to explore […]

How To & Performance

"LOCK TABLE" can harm your database's health

by Laurenz Albe | 03.2019

Many people know that explicit table locks with LOCK TABLE are bad style and usually a consequence of bad […]

Performance

"Exclusive backup" method is deprecated - what now?

by Laurenz Albe | 02.2019

UPDATE 12.07.2022: The “exclusive backup” method of calling pg_start_backup('label') before backup and pg_stop_backup() afterwards has been removed in PostgreSQL […]

How To

« Previous 1 … 6 7 8 9 10 Next »