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

The shibboleth of PostgreSQL

by Laurenz Albe | 12.2020

After all the technical articles I have written, I thought it would be nice to write about PostgreSQL sociology […]

Is UPDATE the same as DELETE + INSERT in PostgreSQL?

by Laurenz Albe | 12.2020

Introduction We know that PostgreSQL does not update a table row in place. Rather, it writes a new version […]

Dealing with streaming replication conflicts in PostgreSQL

by Laurenz Albe | 11.2020

Streaming replication in PostgreSQL is a well-established master-slave replication technique. It is simple to set up, stable and performs […]

HOT updates in PostgreSQL for better performance

by Laurenz Albe | 09.2020

UPDATED blog article on 09.01.2023 HOT updates are not a new feature. They were introduced by commit 282d2a03dd in 2007 […]

Tuning PostgreSQL autovacuum

by Laurenz Albe | 08.2020

In many PostgreSQL databases, you never have to think or worry about tuning autovacuum. It runs automatically in the […]

Understanding recursive queries in PostgreSQL

by Laurenz Albe | 08.2020

Many people consider recursive queries a difficult topic. Still, they enable you to do things that would otherwise be […]

Join strategies and performance in PostgreSQL

by Laurenz Albe | 06.2020

(Updated 2023-02-24) There are three join strategies in PostgreSQL that work quite differently. If PostgreSQL chooses the wrong strategy, […]

Deduplication in PostgreSQL v13 B-tree indexes

by Laurenz Albe | 06.2020

A while ago, I wrote about B-tree improvements in v12. PostgreSQL v13, which will come out later this year, […]

News & Performance

Binary data performance in PostgreSQL

by Laurenz Albe | 05.2020

A frequently asked question in this big data world is whether it is better to store binary data inside […]

PostgreSQL v13 new feature: tuning autovacuum on insert-only tables

by Laurenz Albe | 04.2020

Most people know that autovacuum is necessary to get rid of dead tuples. These dead tuples are a side […]

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