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

ALTER TABLE: High-Availability taken care of

by Hans-Jürgen Schönig | 01.2018

High availability in PostgreSQL: When running an application in production, it might happen that the data structure has to be […]

Performance

PostgreSQL: Speeding up GROUP BY and joins

by Hans-Jürgen Schönig | 12.2017

A couple of weeks ago I have seen a horribly designed, 370 billion (with a “b”) row Oracle database monster […]

Performance

Creating 1 million users in PostgreSQL

by Hans-Jürgen Schönig | 12.2017

While I was at database training to migrate some poor fellows from Oracle to PostgreSQL, I was confronted with this […]

How To

Searching for the best compromise: “Skyline” queries

by Hans-Jürgen Schönig | 12.2017

Ever since Hannes Eder published the idea of the SKYLINE OF operator on the PostgreSQL mailing list years ago, I […]

Performance

pg_crash: Making database crashes great again

by Hans-Jürgen Schönig | 11.2017

Some of you might have seen Kaarel Moppel's talk about pg_crash at pgconfeu 2017 in Warsaw. However, for those who […]

News

Distributed aggregates / aggregate pushdown in PostgreSQL

by Hans-Jürgen Schönig | 10.2017

PostgreSQL 10 will provide end users with countless new features. One of those features is related to “Foreign Data Wrappers” […]

News

Visualizing data in PostgreSQL with R Shiny

by Hans-Jürgen Schönig | 09.2017

R is a free Open Source programming language and statistics package that is excellent for data analysis, statistics and graphics. […]

How To

Autovacuum wraparound protection in PostgreSQL

by Hans-Jürgen Schönig | 08.2017

Autovacuum is maybe one of the most beloved, but also one of the most misunderstood features in the PostgreSQL world. […]

How To

Finding patterns in timeseries: A poor man's method

by Hans-Jürgen Schönig | 07.2017

UPDATED August 2023: Analyzing timeseries is critical. For basic timeseries, ordinary analysis is definitely more than sufficient. Additional tooling is […]

How To