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

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.

PostgreSQL: int4 vs. float4 vs. numeric

by Hans-Jürgen Schönig | 01.2021
PostgreSQL offers many different data types. This post will focus on three important ones: the integer, float and numeric types.

Upgrading and updating PostgreSQL

by Hans-Jürgen Schönig | 12.2020
Update/ upgrade: what's the difference? This blog post covers the best ways of upgrading or updating PostgreSQL to the latest release.
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.

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