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

Entity-attribute-value (EAV) design in PostgreSQL - don't do it!

by Laurenz Albe | 11.2021
  Customers have often asked me what I think of “Entity-attribute-value” (EAV) design. So I thought it would be a […]

TCP keepalive for a better PostgreSQL experience

by Laurenz Albe | 10.2021
  (Updated 2023-06-22) If you've heard about TCP keepalive but aren't sure what that is, read on. If you've ever […]

WITH HOLD cursors and transactions in PostgreSQL

by Laurenz Albe | 10.2021
  Both cursors and transactions are basic ingredients for developing a database application. This article describes how cursors and transactions […]

Gaps in sequences in PostgreSQL

by Laurenz Albe | 09.2021
  Most database tables have an artificial numeric primary key, and that number is usually generated automatically using a sequence. […]

JSON in PostgreSQL: how to use it right

by Laurenz Albe | 09.2021
  The comprehensive JSON support in PostgreSQL is one of its best-loved features. Many people – particularly those with a […]

Index bloat reduced in PostgreSQL v14

by Laurenz Albe | 09.2021
  PostgreSQL v12 brought more efficient storage for indexes, and v13 improved that even more by adding deduplication of index […]

From MD5 to scram-sha-256 in PostgreSQL

by Laurenz Albe | 06.2021
  Since v10, PostgreSQL has provided support for scram-sha-256 for password hashing and authentication. This article describes how you can […]

About cross join in PostgreSQL

by Laurenz Albe | 06.2021
  For many people, “cross join” is something to be afraid of. They remember the time when they forgot the […]

Disabling autocommit in PostgreSQL can damage your health

by Laurenz Albe | 06.2021
  When analyzing customer's problems, I have seen the mess you can get into if you disable autocommit in your […]

How to interpret PostgreSQL EXPLAIN ANALYZE output

by Laurenz Albe | 05.2021
  UPDATED July 2023: EXPLAIN ANALYZE is the key to optimizing SQL statements in PostgreSQL. This article does not attempt […]
1 … 3 4 5 6 7 … 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