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

Pagination and the problem of the total result count

by Laurenz Albe | 01.2023
  When processing a big result set in an interactive application, you want to paginate the result set, that is, […]

UNION ALL, data types and performance

by Laurenz Albe | 12.2022
  A while ago, I wrote about the performance impact of query parameter data types. Recently I encountered a similar […]

EXPLAIN that parameterized statement in PostgreSQL!

by Laurenz Albe | 11.2022
  For detailed query performance analysis, you need EXPLAIN (ANALYZE, BUFFERS) output for an SQL statement. With a parameterized statement, […]

Rewrite OR to UNION in PostgreSQL queries

by Laurenz Albe | 11.2022
  In my article that reviles OR, I showed how in certain cases, it is possible to rewrite OR in […]

Why are my PostgreSQL updates getting slower?

by Laurenz Albe | 10.2022
  Recently, a customer asked me why a bulk load into a PostgreSQL table kept slowing down as time went […]

How to corrupt your PostgreSQL database

by Laurenz Albe | 08.2022
Of course most people do not want to corrupt their databases. These people will profit from avoiding the techniques used […]

Better SQL functions in PostgreSQL v14

by Laurenz Albe | 07.2022
We all know and value SQL functions as a handy shortcut. PostgreSQL v14 has introduced a new, better way to […]

Transaction anomalies with SELECT FOR UPDATE

by Laurenz Albe | 06.2022
  I was recently confronted with a nice example of how adding FOR UPDATE to a query can introduce transaction […]

Debugging deadlocks in PostgreSQL

by Laurenz Albe | 06.2022
  (Updated 2023-04-07) Even if you understand what a deadlock is, debugging deadlocks can be tricky. This article shows some […]

Case-insensitive pattern matching in PostgreSQL

by Laurenz Albe | 06.2022
    (Updated on 2024-11-27) Case-insensitive search is a much-requested feature, partly (I suspect) to maintain compatibility with Microsoft SQL […]
1 2 3 4 5 6 … 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