Home/Laurenz Albe
Author

Laurenz Albe

60 articles by Laurenz Albe.

Engineering — Don't dream it, be it!

Don't dream it, be it!

Read about my experience as Slonik the elephant at the PGConf EU 2026 and become a conference volunteer yourself!

LALaurenz Albe·November 10, 2026Engineering
Security — When is a function leakproof?

When is a function leakproof?

This article discusses row-level security, security barrier functions and leakproof functions, which are necessary to make them work.

LALaurenz Albe·June 2, 2026Security
Engineering — The bastard DBA from hell

The bastard DBA from hell

Two little stories from the working life of the bastard DBA from hell, fighting user problems (but mostly users).

LALaurenz Albe·November 12, 2025Engineering
Performance — Benefits of a DESCending index

Benefits of a DESCending index

The DESC clause in CREATE INDEX is rarely needed. I'll show use cases for descending indexes, including storage efficiency and performance.

LALaurenz Albe·October 21, 2025Performance