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

Foreign Key Indexing and Performance in PostgreSQL

by Laurenz Albe | 10.2018
Foreign key constraints are an important tool to keep your database consistent while also documenting relationships between tables. A fact […]

Correlation of PostgreSQL columns explained

by Laurenz Albe | 09.2018
After you ANALYZE a PostgreSQL table to collect value distribution statistics, you will find the gathered statistics for each column […]

Rules or triggers to log bulk updates?

by Laurenz Albe | 07.2018
  Inspired by my co-worker's recent blog post, I decided to revisit the old question of rules vs. triggers and […]

Adding an index can decrease SELECT performance

by Laurenz Albe | 06.2018
  We all know that you have to pay a price for a new index you create — data modifying […]

Linux cgroups for PostgreSQL

by Laurenz Albe | 05.2018
  In a recent wrestling match with the Linux “out-of-memory killer” for a CYBERTEC customer I got acquainted with Linux […]

Avoiding “OR” for better query performance

by Laurenz Albe | 05.2018
  PostgreSQL query tuning is our daily bread at CYBERTEC, and once you have done some of that, you'll start […]

What's in an xmax?

by Laurenz Albe | 04.2018
xmax is a PostgreSQL system column that is used to implement Multiversion Concurrency Control (MVCC). The documentation is somewhat terse: […]

Get rid of your unused indexes!

by Laurenz Albe | 04.2018
Why should I get rid of unused indexes? Everybody knows that a database index is a good thing because it […]

Four reasons why VACUUM won't remove dead rows from a table

by Laurenz Albe | 03.2018
Why vacuum? Whenever rows in a PostgreSQL table are updated or deleted, dead rows are left behind. VACUUM gets rid […]

New features for sequences: gains and pitfalls

by Laurenz Albe | 02.2018
About sequences Sequences are used to generate artificial numeric primary key columns for tables. A sequence provides a “new ID” […]
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
RรถmerstraรŸe 19
2752 Wรถllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

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