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

View permissions and row-level security in PostgreSQL

by Laurenz Albe | 06.2022
  The details of how view permissions are checked have long puzzled me. PostgreSQL v15 introduces “security invoker” views, which […]

How to cancel a hanging PostgreSQL query

by Laurenz Albe | 05.2022
  Sometimes a PostgreSQL query takes forever. Usually, it is easy to interrupt (cancel) such a statement, but sometimes it […]

Time zone management in PostgreSQL

by Laurenz Albe | 05.2022
  Next to character encoding, time zones are among the least-loved topics in computing. In addition, PostgreSQL's implementation of timestamp […]

How to DROP ROLE or DROP USER in PostgreSQL

by Laurenz Albe | 03.2022
  You might, at first glance, believe that DROP ROLE (or DROP USER, which is the same) is a simple […]

Query parameter data types and performance

by Laurenz Albe | 03.2022
  Recently, I could help solve a “mysterious” performance problem for a customer. The problem turned out to be a […]

Pipeline mode for better PostgreSQL performance on slow networks

by Laurenz Albe | 03.2022
  It is known that high network latency is bad for database performance. PostgreSQL v14 has introduced “pipeline mode” for […]

Automatic partition creation in PostgreSQL

by Laurenz Albe | 02.2022
  Table partitioning is one of the best-liked features out of the more recent PostgreSQL developments. However, there is no […]

Entity-attribute-value (EAV) design in PostgreSQL - don't do it!

by Laurenz Albe | 11.2021
  Customers have often asked me what I think of “Entity-attribute-value” (EAV) design. So I thought it would be a […]

TCP keepalive for a better PostgreSQL experience

by Laurenz Albe | 10.2021
  (Updated 2023-06-22) If you've heard about TCP keepalive but aren't sure what that is, read on. If you've ever […]

WITH HOLD cursors and transactions in PostgreSQL

by Laurenz Albe | 10.2021
  Both cursors and transactions are basic ingredients for developing a database application. This article describes how cursors and transactions […]
1 … 3 4 5 6 7 … 11
CYBERTEC Logo white
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