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

Forcing a join order in PostgreSQL

by Laurenz Albe | 05.2023

Different from many other database systems, PostgreSQL does not support query hints. That makes it difficult to force the […]

Docker and sudden death for PostgreSQL

by Laurenz Albe | 05.2023

This is a short war story from a customer problem. It serves as a warning that there are special […]

EXPLAIN (GENERIC_PLAN): New in PostgreSQL 16

by Laurenz Albe | 04.2023

A while ago, I wrote about how difficult it is to get an execution plan for a parameterized query. […]

Row locks in PostgreSQL

by Laurenz Albe | 04.2023

The PostgreSQL documentation has some information about row locks. But typically, you cannot see them in pg_locks, and not […]

How To & Performance

Breaking your PostgreSQL database with bad CHECK constraints

by Laurenz Albe | 03.2023

I am on a spree! After writing about breaking your database and transaction ID wraparound, here I am writing […]

Transaction ID wraparound: a walk on the wild side

by Laurenz Albe | 01.2023

Most people are aware of transaction ID wraparound. The concept has been well explained in Hans' article, so I […]

A unique constraint where NULL conflicts with everything

by Laurenz Albe | 01.2023

I have been faced with a request for an unusual unique constraint that puzzled me for a while. Since […]

Pagination and the problem of the total result count

by Laurenz Albe | 01.2023

When processing a big result set in an interactive application, you want to paginate the result set, that is, […]

How To & Performance

UNION ALL, data types and performance

by Laurenz Albe | 12.2022

A while ago, I wrote about the performance impact of query parameter data types. Recently I encountered a similar […]

EXPLAIN that parameterized statement in PostgreSQL!

by Laurenz Albe | 11.2022

For detailed query performance analysis, you need EXPLAIN (ANALYZE, BUFFERS) output for an SQL statement. With a parameterized statement, […]

« Previous 1 2 3 4 5 … 10 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