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

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

Tuning max_connections in PostgreSQL

by Laurenz Albe | 04.2020
  (Updated 2023-02-22) In my daily work, I see many databases with a bad setting for max_connections. There is little […]

Embedded SQL in C for PostgreSQL with ecpg

by Laurenz Albe | 03.2020
  Embedded SQL is by no means a new feature — in fact it is so old-fashioned that many people […]

Subtransactions and performance in PostgreSQL

by Laurenz Albe | 03.2020
  (Last updated on 2023-01-24) Recently, while troubleshooting PostgreSQL performance problems, I ran into problems with subtransactions twice. So I […]

recovery.conf is gone in PostgreSQL v12

by Laurenz Albe | 12.2019
  The biggest change in PostgreSQL v12 from the viewpoint of backward compatibility is that recovery.conf has been absorbed into […]

B-tree index improvements in PostgreSQL v12

by Laurenz Albe | 11.2019
  If you thought that the B-tree index is a technology that was perfected in the 1980s, you are mostly […]

Never lose a PostgreSQL transaction with pg_receivewal

by Laurenz Albe | 10.2019
    “Durability”, the D of ACID, demands that a committed database transaction remains committed, no matter what. For normal […]

Manage Linux control groups in PostgreSQL with pg_cgroups

by Laurenz Albe | 09.2019
(This article and the extension pg_cgroups was written for cgroups v1. The extension won't work with cgroups v2, but the […]

Tracking view dependencies in PostgreSQL

by Laurenz Albe | 09.2019
  We all know that in PostgreSQL we cannot drop an object if there are view dependencies on it: [crayon-67685e4a4c205897039373/] […]
1 … 6 7 8 9 10 11
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
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