CYBERTEC PostgreSQL Logo
Ants Aasma Profile Picture

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.
github icon

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, […]
1 5 6 7 8 9 11
CYBERTEC Logo white
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram