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

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

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

Bulk load performance in PostgreSQL

by Laurenz Albe | 08.2023
  There are several techniques to bulk load data into PostgreSQL. I decided to compare their performance in a simple […]

Subqueries and performance in PostgreSQL

by Laurenz Albe | 07.2023
  SQL allows you to use subqueries almost anywhere where you could have a table or column name. All you […]

Memory context: private memory management in PostgreSQL

by Laurenz Albe | 06.2023
  PostgreSQL uses shared memory for data shared between processes. With the exception of the dynamic shared memory segments used […]
1 2 3 4 … 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