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

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.

Swiss PGDay 2024 and PG conferences in general

by Laurenz Albe | 07.2024
Read about my impressions from the Swiss PGDay 2024 and learn why you should attend PostgreSQL conferences yourself.

Making the PostgreSQL visibility map visible

by Laurenz Albe | 06.2024
This article explains how to examine the PostgreSQL visibility map and showcases performance improvements added in recent releases.

Why do I have a slow COMMIT in PostgreSQL?

by Laurenz Albe | 05.2024
This article describes the possible reasons for a slow COMMIT in PostgreSQL and discusses what you can to against that.

cursor_tuple_fraction and the PostgreSQL JDBC driver

by Laurenz Albe | 05.2024
A little failure story about the parameter cursor_tuple_fraction and how it interacts with the PostgreSQL JDBC driver.

Syslog logging with journald in PostgreSQL

by Laurenz Albe | 04.2024
This article explains how to configure syslog logging in PostgreSQL and shows how to view and manage the log with journald.

PostgreSQL parallel query problems in JDBC and DBeaver

by Laurenz Albe | 01.2024
By default, PostgreSQL does not use parallel query when you use DBeaver. This article describes the cause and how to fix it.
1 2 3 … 11
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

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

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