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 track_activity_query_size in postgresql.conf

by Hans-Jürgen Schönig | 10.2019

How to use track_activity_query_size, a configuration parameter that determines when a query will be cut off. Use it to your advantage.

How To

Using “Row Level Security” to make large companies more secure

by Hans-Jürgen Schönig | 09.2019

How to use row level security to restrict internal access to PostgreSQL databases. How to configure access restrictions dynamically.

How To

PostgreSQL Row Level Security, views and a lot of magic

by Hans-Jürgen Schönig | 08.2019

How to implement row-level security in PostgreSQL and views. Shows examples and corner cases to watch out for.

How To

Timeseries: EXCLUDE TIES, CURRENT ROW and GROUP

by Hans-Jürgen Schönig | 08.2019

UPDATED 2023: How to use advanced SQL for timeseries in PostgreSQL - window functions, analytics. EXCLUDE TIES, CURRENT ROW & GROUP

How To

PostgreSQL: Trivial timeseries examples

by Hans-Jürgen Schönig | 08.2019

How to use the PostgreSQL function lag() and corr() - see basic examples and get familiar with window functions for trivial timeseries.

How To

Composite/ combined indexes vs. separate indexes in PostgreSQL

by Hans-Jürgen Schönig | 07.2019

What is more beneficial: Using separate or combined indexes in your PostgreSQL database? Speed performance by understanding index scans.

How To

PostgreSQL: How are functions and stored procedures replicated?

by Hans-Jürgen Schönig | 07.2019

How are functions replicated in PostgreSQL? Find out about functions, stored procedures and replication. What happens to shared libraries & do I need to install an extension everywhere?

How To