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

Fixing out-of-sync sequences in PostgreSQL

by Hans-Jürgen Schönig | 08.2021

This post shows how to deal with out of sync PostgreSQL sequences in underlying tables using open-source pg_sequence_fixer extension

How To

PostgreSQL grouping sets: ROLLUP & CUBE

by Hans-Jürgen Schönig | 08.2021

PostgreSQL offers many OLAP-style workload features. One of those features is called “GROUPING SETS”. Let's deep dive into ROLLUP & CUBE:

How To

PostgreSQL Security: 12 rules for database hardening

by Hans-Jürgen Schönig | 07.2021

UPDATED August 2023: PostgreSQL security - make your database safe. Follow these 12 recommendations for proactive database hardening.

How To

PostgreSQL zheap: Current status

by Hans-Jürgen Schönig | 07.2021

zheap has been designed as a new storage engine to handle UPDATE in PostgreSQL more efficiently. Read about the current status and more.

News

PostgreSQL: LIMIT vs FETCH FIRST ROWS ... WITH TIES

by Hans-Jürgen Schönig | 07.2021

The LIMIT/OFFSET clause is off standard and thus not portable. Read about the proper way to handle it by using “SELECT … FETCH FIRST ROWS”.

How To

Understanding LATERAL joins in PostgreSQL

by Hans-Jürgen Schönig | 07.2021

LATERAL joins are extremely useful & can be utilized in many cases to speed up operations, or to simply make code a lot easier to understand.

How To

Constraints over multiple rows in PostgreSQL

by Hans-Jürgen Schönig | 06.2021

Constraints over multiple rows: How to cope with complex PostgreSQL constraints. Advanced techniques - enforce integrity; manage concurrency.

How To

Creating and refreshing materialized views in PostgreSQL

by Hans-Jürgen Schönig | 06.2021

A “materialized view” is an integral feature of every advanced database system. How can you make use of materialized views in PostgreSQL?

How To

Data warehousing: Making use of synchronized seq scans

by Hans-Jürgen Schönig | 06.2021

Did you know PostgreSQL has the ability to synchronize sequential scans? If you are running data warehouses, you might have already used it without knowing.

Performance