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

Use HOT, so CLUSTER won't rot in PostgreSQL

by Laurenz Albe | 06.2023

CLUSTER is sometimes the last resort to squeeze performance out of an index scan. Normally, you have to repeat CLUSTER […]

How To & Performance

ERROR: invalid byte sequence - Fix bad encoding in PostgreSQL

by Laurenz Albe | 05.2023

(Inscription seen on a T-shirt) It's annoying to get error messages caused by encoding problems. But it is more annoying […]

PostgreSQL ALTER DEFAULT PRIVILEGES - permissions explained

by Laurenz Albe | 05.2023

Many people have heard that ALTER DEFAULT PRIVILEGES makes it easy to allow other users access to tables. But […]

Forcing a join order in PostgreSQL

by Laurenz Albe | 05.2023

Different from many other database systems, PostgreSQL does not support query hints. That makes it difficult to force the […]

Docker and sudden death for PostgreSQL

by Laurenz Albe | 05.2023

This is a short war story from a customer problem. It serves as a warning that there are special […]

EXPLAIN (GENERIC_PLAN): New in PostgreSQL 16

by Laurenz Albe | 04.2023

A while ago, I wrote about how difficult it is to get an execution plan for a parameterized query. […]

Row locks in PostgreSQL

by Laurenz Albe | 04.2023

The PostgreSQL documentation has some information about row locks. But typically, you cannot see them in pg_locks, and not […]

How To & Performance

Breaking your PostgreSQL database with bad CHECK constraints

by Laurenz Albe | 03.2023

I am on a spree! After writing about breaking your database and transaction ID wraparound, here I am writing about […]

Transaction ID wraparound: a walk on the wild side

by Laurenz Albe | 01.2023

Most people are aware of transaction ID wraparound. The concept has been well explained in Hans' article, so I […]

A unique constraint where NULL conflicts with everything

by Laurenz Albe | 01.2023

I have been faced with a request for an unusual unique constraint that puzzled me for a while. Since […]

« Previous 1 2 3 4 5 … 11 Next »

Stay tuned with our

NEWSLETTER

CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Customer Support

Support Platform

Services

Support CYBERTEC Partner PostgreSQL Books

Company

STAY TUNED WITH OUR NEWSLETTER

Get the newest PostgreSQL Info & Tools

Data Protection Policy Terms and conditions Terms of Service Imprint

©

2024

CYBERTEC PostgreSQL International GmbH