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

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

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

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