CYBERTEC PostgreSQL Logo
Ants Aasma Profile Picture

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.
github icon

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 […]

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 […]

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 […]
1 2 3 4 5 … 11
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram