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

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 […]

Indexing "LIKE" in PostgreSQL and Oracle

by Laurenz Albe | 08.2023
© Laurenz Albe 2023 Unless you use the binary collation, creating a b-tree index to support a LIKE condition in […]

Why does my pg_wal keep growing?

by Laurenz Albe | 08.2023
  "Why does my pg_wal keep growing?" That's a question I keep hearing again and again. It is an urgent […]
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
    phone-handsetmagnifiercrosscross-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram