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

Foreign data wrapper for PostgreSQL: Performance Tuning

by Hans-Jürgen Schönig | 03.2019

Foreign data wrappers are one of the most widely used feature in PostgreSQL. People simply like foreign data wrappers and […]

Performance

unaccent: Getting rid of umlauts, accents and special characters

by Hans-Jürgen Schönig | 03.2019

Database people dealing with natural languages are all painfully aware of the fact that encodings, special characters, accents and alike […]

How To

Implementing “AS OF”-queries in PostgreSQL

by Hans-Jürgen Schönig | 02.2019

Over the years many people have asked for “timetravel” or “AS OF”-queries in PostgreSQL. Oracle has provided this kind of […]

How To

pg_permissions: Inspecting your PostgreSQL security system

by Hans-Jürgen Schönig | 01.2019

Security is an important topic. This is not only true in the PostgreSQL world – it holds truth for pretty […]

How To

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

by Hans-Jürgen Schönig | 12.2018

After years of software development, some might still wonder: What is a NULL value? What does it really mean and […]

How To

Transactions in PostgreSQL: READ COMMITTED vs. REPEATABLE READ

by Hans-Jürgen Schönig | 11.2018

The ability to run transactions is the core of every modern relational database system. The idea behind a transaction is […]

How To

PostgreSQL: Implicit vs. explicit joins

by Hans-Jürgen Schönig | 11.2018

If you happen to be an SQL developer, you will know that joins are really at the core of the […]

How To & Performance

PostgreSQL: Parallel CREATE INDEX for better performance

by Hans-Jürgen Schönig | 09.2018

As of PostgreSQL 11 postgres users have the ability to create indexes in parallel. For many years various commercial database […]

Performance

What hot_standby_feedback in PostgreSQL really does

by Hans-Jürgen Schönig | 08.2018

Many of you out there using PostgreSQL streaming replication might wonder what this hot_standby_feedback parameter in postgresql.conf really does. Support […]

How To

Sort Performance in PostgreSQL

by Hans-Jürgen Schönig | 08.2018

Sorting is a very important aspect of PostgreSQL performance tuning. However, improving sort performance is often misunderstood or simply overlooked […]

Performance