CYBERTEC PostgreSQL Logo
Ants Aasma Profile Picture

Hans-Jürgen Schönig

Founder & CEO of CYBERTEC
Hans-Jürgen Schönig has worked with PostgreSQL since the 90's. He is the CEO and technical lead of CYBERTEC PostgreSQL International, a market leader in the field. He's served countless customers around the globe since the year 2000. He is also the author of the well-received "Mastering PostgreSQL" book series, as well as several other books about PostgreSQL replication and administration.

Articles by Hans-Jürgen Schönig

PostgreSQL: Using CREATE USER with caution

by Hans-Jürgen Schönig | 05.2019
There are good reasons why CREATE USER should be used cautiously. Find out why, and why you should distinguish between users and roles.

DECLARE CURSOR in PostgreSQL or how to reduce memory consumption

by Hans-Jürgen Schönig | 04.2019
This blogpost is about using cursors in PostgreSQL, their purpose and limitations and what DECLARE CURSOR and FETCH have to do with it.

Speeding up GROUP BY in PostgreSQL

by Hans-Jürgen Schönig | 03.2019
How to speed up GROUP BY statements in PostgreSQL. Follow some basic rules & you will squeeze performance out of the database for free.

Foreign data wrapper for PostgreSQL: Performance Tuning

by Hans-Jürgen Schönig | 03.2019
fdw performance tuning - hidden tuning options which are not widely known. Let's see how to speed up the PostgreSQL foreign data wrapper.

unaccent: Getting rid of umlauts, accents and special characters

by Hans-Jürgen Schönig | 03.2019
Unaccent is a useful PostgreSQL extension for improving user experience. Get insight into this extension and its purpose.

Implementing “AS OF”-queries in PostgreSQL

by Hans-Jürgen Schönig | 02.2019
Many databases such as Oracle provide "AS OF" queries (timetravel). This blog explains how to do time travel in PostgreSQL.

pg_permissions: Inspecting your PostgreSQL security system

by Hans-Jürgen Schönig | 01.2019
pg_permissions is a tool display the security settings of your database. Get a quick overview of what's going on inside your security.

A PostgreSQL story about "NULL IS NULL = NULL AND NOT NULL"

by Hans-Jürgen Schönig | 12.2018
Why the word "unknown" is better to describe a NULL value than "empty". Learn to use NULL values correctly in PostgreSQL.

Transactions in PostgreSQL: READ COMMITTED vs. REPEATABLE READ

by Hans-Jürgen Schönig | 11.2018
How to use the two most common transaction isolation levels in PostgreSQL: READ COMMITTED and REPEATABLE READ.

PostgreSQL: Implicit vs. explicit joins

by Hans-Jürgen Schönig | 11.2018
How to use implicit and explicit joins in PostgreSQL. What are the performance differences between these two types of join?
1 … 13 14 15 16 17 … 29
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.

    ©
    2025
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram