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

Timeseries: EXCLUDE TIES, CURRENT ROW and GROUP

by Hans-Jürgen Schönig | 08.2019

UPDATED July 2023: Window functions and analytics have been around for quite some time and many people already make use […]

How To

PostgreSQL: Trivial timeseries examples

by Hans-Jürgen Schönig | 08.2019

Trivial timeseries are an increasingly important topic - not just in PostgreSQL. Recently I gave a presentation @AGIT in Salzburg […]

How To

Composite/ combined indexes vs. separate indexes in PostgreSQL

by Hans-Jürgen Schönig | 07.2019

A “composite index”, also known as “concatenated index” or a combined index, is an index on multiple columns in a […]

How To

PostgreSQL: How are functions and stored procedures replicated?

by Hans-Jürgen Schönig | 07.2019

When looking at our PostgreSQL support activities, we notice that people often ask about functions, stored procedures and replication. Are […]

How To

PostgreSQL meets “Data Science and AI”

by Hans-Jürgen Schönig | 07.2019

Machine Learning, Deep Learning, Artificial Intelligence, and Data Science have become really important topics these days. Everybody is looking for […]

How To