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

Index bloat reduced in PostgreSQL v14

by Laurenz Albe | 09.2021

PostgreSQL v12 brought more efficient storage for indexes, and v13 improved that even more by adding deduplication of index […]

News & Performance

From MD5 to scram-sha-256 in PostgreSQL

by Laurenz Albe | 06.2021

Since v10, PostgreSQL has provided support for scram-sha-256 for password hashing and authentication. This article describes how you can […]

About cross join in PostgreSQL

by Laurenz Albe | 06.2021

For many people, “cross join” is something to be afraid of. They remember the time when they forgot the […]

Disabling autocommit in PostgreSQL can damage your health

by Laurenz Albe | 06.2021

When analyzing customer's problems, I have seen the mess you can get into if you disable autocommit in your […]

How to interpret PostgreSQL EXPLAIN ANALYZE output

by Laurenz Albe | 05.2021

UPDATED July 2023: EXPLAIN ANALYZE is the key to optimizing SQL statements in PostgreSQL. This article does not attempt […]

UUID, serial or identity columns for PostgreSQL auto-generated primary keys?

by Laurenz Albe | 05.2021

UPDATED 14.05.2022: Sometimes customers ask me about the best choice for auto-generated primary keys. In this article, I'll explore […]

What to return from a PostgreSQL row level trigger?

by Laurenz Albe | 04.2021

In this article, I'll talk about row level triggers, which are the most frequently used kind of triggers. I […]

When to use tablespaces in PostgreSQL

by Laurenz Albe | 03.2021

Users with an Oracle background consider tablespaces very important and are surprised that you can find so little information […]

New target_session_attrs settings for high availability and scaling in PostgreSQL v14

by Laurenz Albe | 03.2021

PostgreSQL commit ee28cacf61 has added new options for the target_session_attrs connection parameter. This article explores how the new options […]

Estimating connection pool size with PostgreSQL database statistics

by Laurenz Albe | 02.2021

PostgreSQL v14 has new connection statistics in pg_stat_database. In this article, I want to explore one application for them: […]

« Previous 1 … 4 5 6 7 8 … 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