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

Exploding runtime: How nested loops can destroy speed

by Hans-Jürgen Schönig | 08.2016

Sometimes it happens that a query slows down dramatically for no obvious reason. In other cases queries go south in […]

Performance

paginators - The story about voluntary pain in PostgreSQL

by Hans-Jürgen Schönig | 08.2016

It happens on a quite regular basis that people contact the CYBERTEC PostgreSQL Support Desk to get support for a […]

How To

Inheritance - One more reason to love PostgreSQL

by Hans-Jürgen Schönig | 07.2016

After doing full-time PostgreSQL consulting for over 16 years now, I actually don't remember a time without inheritance anymore. Of […]

How To

PostgreSQL exclusion constraints: Beyond UNIQUE

by Hans-Jürgen Schönig | 07.2016

UPDATED AUGUST 2023: A couple of years ago, PostgreSQL introduced so called “exclusion constraints”, which are defined with the EXCLUDE […]

How To

PostgreSQL instance-level encryption

by Hans-Jürgen Schönig | 06.2016

We recently published a patch to provide full database encryption for PostgreSQL. Many business-critical applications require full encryption to match […]

News