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

pg_basebackup: Creating self-sufficient backups

by Hans-Jürgen Schönig | 12.2016

UPDATED Aug 2023 How to use pg_basebackup: allows users to create a binary copy of their data, which is the basis for Point-In-Time-Recovery.

How To

Parallel queries and SERIALIZABLE transactions

by Hans-Jürgen Schönig | 11.2016

In version 9.6 PostgreSQL introduced parallel queries. The ability to use more than just one CPU core per query is […]

Performance

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