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: How to write a trigger

by Hans-Jürgen Schönig | 02.2021

Just like in most databases, in PostgreSQL a trigger is a way to automatically respond to events. Maybe you want […]

How To

PostgreSQL: CREATE STATISTICS - advanced query optimization

by Hans-Jürgen Schönig | 02.2021

PostgreSQL query optimization with CREATE STATISTICS is an important topic. Usually, the PostgreSQL optimizer (query planner) does an excellent job. […]

Performance

PostgreSQL: ANALYZE and optimizer statistics

by Hans-Jürgen Schönig | 02.2021

Our PostgreSQL 24x7 support team recently received a request from one of our customers who was facing a performance problem. […]

Performance

Patroni Environment Setup: PostgreSQL High Availability for Windows

by Hans-Jürgen Schönig | 02.2021

PostgreSQL High-Availability has been one of the most dominant topics in the field for a long time. While there are […]

How To

PostgreSQL: What is a checkpoint?

by Hans-Jürgen Schönig | 02.2021

Checkpoints are a core concept in PostgreSQL. However, many people don’t know what they actually are, nor do they understand […]

Performance

Monitoring replication: pg_stat_replication

by Hans-Jürgen Schönig | 01.2021

PostgreSQL replication (synchronous and asynchronous replication) is one of the most widespread features in the database community. Nowadays, people are […]

How To