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

Will more disks get you better PostgreSQL performance?

by Hans-Jürgen Schönig | 09.2016

Find out whether to buy more hardware to fix performance problems - which are in many cases not caused by bad disk performance.

Performance

Exploding runtime: How nested loops can destroy speed

by Hans-Jürgen Schönig | 08.2016

What will happen if the PostgreSQL optimizer underestimates the number of rows involved in nested loops? Includes ways to fix the problem.

Performance

paginators - The story about voluntary pain in PostgreSQL

by Hans-Jürgen Schönig | 08.2016

If you want to display millions of entries on your website, you definitely turn to paginators. Here's how you do it right using PostgreSQL.

How To

Inheritance - One more reason to love PostgreSQL

by Hans-Jürgen Schönig | 07.2016

The PostgreSQL feature "inheritance" works like a charm. You ask why? Well, here are the details we really like about it.

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

Business critical applications require full encryption to match legal requirements. We published a patch to provide full database encryption.

News

BRIN indexes: Correlation, correlation, correlation

by Hans-Jürgen Schönig | 06.2016

BRIN indexes have been introduced in PostgreSQL 9.5. While BRIN indexes are definitely a win, people tend to exaggerate and use them far too frequently.

How To