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

Making the PostgreSQL visibility map visible

by Laurenz Albe | 06.2024
Enough has been written about the connection between VACUUM, the visibility map and index-only scans in PostgreSQL. But recently I demonstrated index-only scans […]

Why do I have a slow COMMIT in PostgreSQL?

by Laurenz Albe | 05.2024
  Sometimes one of our customers looks at the most time consuming statements in a database (either with pg_stat_statements or […]

cursor_tuple_fraction and the PostgreSQL JDBC driver

by Laurenz Albe | 05.2024
This article is a kind of failure story. I originally set out to write a piece about the PostgreSQL parameter […]

Syslog logging with journald in PostgreSQL

by Laurenz Albe | 04.2024
Logging to syslog is not a new PostgreSQL feature at all. Still, I find few people using it, so perhaps […]

PostgreSQL parallel query problems in JDBC and DBeaver

by Laurenz Albe | 01.2024
  I recently investigated a surprising behavior of the DBeaver database client in connection with PostgreSQL parallel query, which I'd […]

Broken foreign keys: how can that happen in PostgreSQL?

by Laurenz Albe | 12.2023
  One of the fundamental requirements for a relational database is that the transaction system always maintains consistency. That means […]

What you should know about PostgreSQL minor upgrades

by Laurenz Albe | 12.2023
© Laurenz Albe 2023 The PostgreSQL documentation is rather terse on the subject of minor upgrade. The reason is probably […]

PostgreSQL hash index performance

by Laurenz Albe | 12.2023
  Among the many index types in PostgreSQL, the hash index is the most widely ignored. This came home to […]

Conditional foreign keys and polymorphism in SQL: 4 Methods

by Laurenz Albe | 08.2023
  This article is about the notoriously difficult problem of “conditional foreign keys”. In object-oriented programming languages, polymorphism is a […]

Postgres v16: 14 Cool New Features

by Laurenz Albe | 08.2023
PostgreSQL v16 contains many new features and enhancements. Here are PG v16's 14 best new features: Everybody's favorite: You no longer […]
1 2 3 10
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf

+43 (0) 2622 93022-0

Get the newest PostgreSQL Info & Tools

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

    CYBERTEC PostgreSQL International GmbH
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram