CYBERTEC 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

pgbouncer authentication made easy

by Laurenz Albe | 01.2019
  UPDATED August 2023 pgbouncer is the most widely used connection pooler for PostgreSQL. This blog will provide a simple […]

Be prepared for prepared transactions

by Laurenz Albe | 12.2018
Prepared transactions are disabled in PostgreSQL by default, since the parameter max_prepared_transactions has the default value 0. You don't need […]

Killed index tuples

by Laurenz Albe | 11.2018
  Since I only recently learned about the concept of “killed index tuples”, I thought there might be some others […]

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: […]
1 … 7 8 9 10
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

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

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