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

Swiss Database Synergy Day 2025: Oracle and PostgreSQL User Groups Unite

by Laurenz Albe | 04.2025
My impressions from the Swiss Database Synergy Day 2025, a conference organized by the Swiss Oracle and PostgreSQL user groups

stats_fetch_consistency: caching PostgreSQL monitoring statistics?

by Laurenz Albe | 03.2025
This article describes the little known parameter stats_fetch_consistency and its potential applications for statistics collection.

Comparison of the transaction systems of Oracle and PostgreSQL

by Laurenz Albe | 02.2025
This article offers a comparison between the transaction systems of Oracle and PostgreSQL to help you spot potential migration problems.

Dealing with the PostgreSQL error "found xmin ... from before relfrozenxid ..."

by Laurenz Albe | 02.2025
This article explains the error message "found xmin ... from before relfrozenxid ..." and shows how you can fix the problem.

commit_delay for better performance: a PostgreSQL benchmark

by Laurenz Albe | 01.2025
We benchmark the performance boost that you can get by tuning commit_delay with a workload of small transactions.

The power of open source in PostgreSQL

by Laurenz Albe | 01.2025
The power of open source helps us find out how a PostgreSQL parameter got its value. Unravel history with Git and the mailing list archive!

Dealing with trigger recursion in PostgreSQL

by Laurenz Albe | 10.2024
This article describes the problem of endless trigger recursion in PostgreSQL and shows how to deal with it and get good performance.

What's so great about PostgreSQL v17?

by Laurenz Albe | 10.2024
PostgreSQL v17 has been released. If the list of new features does not inspire you, this article will try to change your mind.

What you should know about Linux memory overcommit in PostgreSQL

by Laurenz Albe | 07.2024
Understand why and how to disable memory overcommit to make PostgreSQL run reliably on Linux, including implications for containerization.

Keyset pagination with descending order

by Laurenz Albe | 07.2024
This article shows how to use keyset pagination if you want to sort some columns in ascending and others in descending order.
1 2 3 4 … 12
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.

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