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.

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

How To & Performance

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

How To & Performance

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

« Previous 1 2 3 4 … 11 Next »

Stay tuned with our

NEWSLETTER

CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Customer Support

Support Platform

Services

Support CYBERTEC Partner PostgreSQL Books

Company

STAY TUNED WITH OUR NEWSLETTER

Get the newest PostgreSQL Info & Tools

Data Protection Policy Terms and conditions Terms of Service Imprint

©

2024

CYBERTEC PostgreSQL International GmbH