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 15: Using MERGE in SQL

by Hans-Jürgen Schönig | 05.2022
Merge - UPDATED 2023 - a technical preview of how to merge lists with ease. Find out about a wonderful command - add power to your PostgreSQL.

Find and fix a missing PostgreSQL Index

by Hans-Jürgen Schönig | 04.2022
Explains how to find a missing Postgresql index, what you can do to fix missing indexes, and how to achieve good database performance.

Multiranges in PostgreSQL 14

by Hans-Jürgen Schönig | 04.2022
Multiranges are a new feature in PostgreSQL 14. Here's a brief introduction on how to use them - learn the basics & important new uses.

PostgreSQL: mapping timestamps (date_bin)

by Hans-Jürgen Schönig | 04.2022
How to map timestamps to time bins: In PostgreSQL 14, a new function date_bin has been added which maps date & time to time buckets.

PostgreSQL: Creating checksums for tables

by Hans-Jürgen Schönig | 03.2022
Learn how checksums and ordered sets are used to compare the content of tables in your PostgreSQL database. Ensure data quality.

Manage encryption keys with PostgreSQL TDE

by Hans-Jürgen Schönig | 12.2021
PostgreSQL TDE is PostgreSQL with on-disk encryption. Here's how to manage encryption keys using PostgreSQL TDE and external keystores.

zheap UNDO logs discarding in PostgreSQL

by Hans-Jürgen Schönig | 12.2021
zheap for PostgreSQL makes UPDATE statements run faster. Try out CYBERTEC's new cleanup worker designed to discard zheap UNDO logs.

pg_rewrite: PostgreSQL Table Partitioning

by Hans-Jürgen Schönig | 12.2021
How to partition an existing table without locking up the database? pg_rewrite can help you with PostgreSQL table partitioning.

Primary Keys vs. UNIQUE Constraints in PostgreSQL

by Hans-Jürgen Schönig | 11.2021
What primary keys and UNIQUE constraints do: Both features create an index, but what makes a primary key different from a unique constraint?

Building an Oracle to PostgreSQL migrator: Lessons learned

by Hans-Jürgen Schönig | 09.2021
Oracle to PostgreSQL migration - Lessons learned in building a migration tool. How to avoid errors, null bytes and broken content.
1 … 4 5 6 7 8 … 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