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

How to do UPDATE ... LIMIT in PostgreSQL

by Laurenz Albe | 09.2025
If you are reading this hoping that PostgreSQL finally got UPDATE ... LIMIT like MySQL, I have to disappoint you. […]

How to handle "database is not accepting commands"

by Laurenz Albe | 09.2025
If you ever get the error message “database is not accepting commands”, you are dangerously close to transaction ID wraparound. […]

Partitioned table statistics

by Laurenz Albe | 09.2025
I recently helped a customer with a slow query. Eventually, an ANALYZE on a partitioned table was enough to fix […]

Should I rebuild my PostgreSQL index?

by Laurenz Albe | 08.2025
People often ask “How can I automatically rebuild by indexes regularly?” or “When should I rebuild my indexes in PostgreSQL?”. […]

Who are the PGDG?

by Laurenz Albe | 07.2025
This article describes what the PGDG (PostgreSQL Global Development Group) is and how you can become a part of it.

Preserve optimizer statistics during major upgrades with PostgreSQL v18

by Laurenz Albe | 06.2025
Everybody wants good performance. When it comes to the execution of SQL statements, accurate optimizer statistics are key. With the […]

SELECT FOR UPDATE considered harmful in PostgreSQL

by Laurenz Albe | 06.2025
Recently, while investigating a deadlock for a customer, I was again reminded how harmful SELECT FOR UPDATE can be for […]

The Fun of Open Source: Roman Numerals in PostgreSQL

by Laurenz Albe | 06.2025
Recently, I wrote about the power of open source. Now, power is good and important, but open source software has […]

Orphaned files after a PostgreSQL crash

by Laurenz Albe | 04.2025
This article describes how a PostgreSQL crash can leave some orphaned files behind and what you can do to get rid of them.

Type alignment and padding bytes: how to not waste space in PostgreSQL tables

by Laurenz Albe | 04.2025
Learn the concepts of data type alignment and padding bytes in PostgreSQL and how to define your table so that you don't waste storage space.
1 2 3 12
CYBERTEC Logo white
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