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

Partitioned table statistics

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

Should I rebuild my PostgreSQL index?

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

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
© Laurenz Albe 2025 Everybody wants good performance. When it comes to the execution of SQL statements, accurate optimizer statistics […]

SELECT FOR UPDATE considered harmful in PostgreSQL

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

The Fun of Open Source: Roman Numerals in PostgreSQL

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

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.

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