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

Keyset pagination with descending order

by Laurenz Albe | 07.2024
Keyset pagination is the most performant way to retrieve a large result set page by page. However, the neat trick […]

Swiss PGDay 2024 and PG conferences in general

by Laurenz Albe | 07.2024
I enjoy writing about the technical aspects of PostgreSQL, but occasionally it is good to write about other aspects of […]

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

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 […]
1 2 3 … 10
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