CYBERTEC PostgreSQL Logo
Ants Aasma Profile Picture

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

How the PostgreSQL query optimizer works

by Hans-Jürgen Schönig | 03.2021
Get insight into how the PostgreSQL optimizer works and how it speeds up queries. Find out about anti-join & from_collapse_limit.

Setting up SSL authentication for PostgreSQL

by Hans-Jürgen Schönig | 03.2021
How to set up SSL authentication for PostgreSQL. Handle secure client server connections in the best possible way.

PostgreSQL: Getting started on Ubuntu

by Hans-Jürgen Schönig | 03.2021
This is a tutorial for using PostgreSQL on Ubuntu. Learn how to download & install PostgreSQL and how to create a database instance & your first table.

PostgreSQL: How to write a trigger

by Hans-Jürgen Schönig | 02.2021
UPDATED 2023: A trigger is a way to automatically respond to events. This is a tutorial on how to manage and program triggers in PostgreSQL.

PostgreSQL: CREATE STATISTICS - advanced query optimization

by Hans-Jürgen Schönig | 02.2021
The PostgreSQL query planner doesn't know which data usually correlates. How to use CREATE STATISTICS to find correlations.

PostgreSQL: ANALYZE and optimizer statistics

by Hans-Jürgen Schönig | 02.2021
To find the best execution plan PostgreSQL is relying on statistics to give the optimizer an indication of what to expect.

Patroni Environment Setup: PostgreSQL High Availability for Windows

by Hans-Jürgen Schönig | 02.2021
Patroni Environment Setup (PES) is a graphical installer for Patroni on Windows which makes it easy to deploy Patroni High-Availability.

PostgreSQL: What is a checkpoint?

by Hans-Jürgen Schönig | 02.2021
How to use checkpoints and checkpoint tuning, and how PostgreSQL writes data, database internals explained.

Monitoring replication: pg_stat_replication

by Hans-Jürgen Schönig | 01.2021
How to make sure that your clusters are properly monitored if you use replication. The best way to do so is to use pg_stat_replication.

Golden Proportions in PostgreSQL

by Hans-Jürgen Schönig | 01.2021
Learn how PostgreSQL can help with basic calculations regarding golden proportions. Do mathematics in your database development work.
1 … 7 8 9 10 11 … 29
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2025
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram