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

Monitoring PostgreSQL replication

by Hans-Jürgen Schönig | 09.2023
How to monitor replication lag in PostgreSQL? What is replication lag? And how to best go about monitoring PostgreSQL replication in general?

Citus: Sharding your first table

by Hans-Jürgen Schönig | 09.2023
Here’s how to shard a table from scratch with Citus. Scale PostgreSQL DBs using a sharding approach. How to run a Citus Docker container.

Killing performance with PostgreSQL partitioning

by Hans-Jürgen Schönig | 07.2023
Partitioning is not without risk. It might help to handle large quantities of data, but it can also have downsides - learn how to it.

What is a schema in PostgreSQL?

by Hans-Jürgen Schönig | 06.2023
What is a schema in PostgreSQL? Why do we need a schema and how can schemas be used to make your life easier? Let's find out.

PostgreSQL: DELETE vs. TRUNCATE

by Hans-Jürgen Schönig | 03.2023
Archiving and database cleanup in PostgreSQL: Find out how DELETE and TRUNCATE compare in terms of performance and how the magic works

PostgREST: Get started with automated PostgreSQL APIs

by Hans-Jürgen Schönig | 03.2023
PostgREST quick-start guide: Writing APIs by hand is a lot of work. PostgREST automatically generates an API out of your PostgreSQL database.

Stored procedures in PostgreSQL: getting started

by Hans-Jürgen Schönig | 02.2023
Learn all about stored procedures in PostgreSQL right here with examples created by a database expert. Includes syntax & tips

PostgreSQL: Finding the current timestamp

by Hans-Jürgen Schönig | 02.2023
How can I find the current timestamp in PostgreSQL? Read more about real time, statement time and transaction time.

Improving GROUP BY with CREATE STATISTICS

by Hans-Jürgen Schönig | 01.2023
For a PostgreSQL time series report - find out how CREATE STATISTICS can improve performance when you group on expressions

JSON logs in PostgreSQL 15

by Hans-Jürgen Schönig | 12.2022
Find out how JSON logs can be configured in PostgreSQL 15 and get all the advantages of this brand new feature
1 3 4 5 6 7 31
CYBERTEC Logo white
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