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

PERFORMANCE TUNING: MAX AND GROUP BY

by Hans-Jürgen Schönig | 04.2024

These days everybody is talking about time series, time series analysis and alike for performance tuning. Analyzing time series data […]

How To

Enforcing join orders in PostgreSQL

by Hans-Jürgen Schönig | 03.2024

After the pgconfeu23 in Prague - which has been an excellent event - I decided to share some of the […]

How To

PostgreSQL: Why true Open Source matters

by Hans-Jürgen Schönig | 01.2024

PGConfEU2023 is over and a New Year has started. For those who did not manage to make it to Prague […]

News

Optimizing PostgreSQL functions with preloaded libraries

by Hans-Jürgen Schönig | 01.2024

In PostgreSQL, functions and procedures can be written in many different programming languages including but not limited to PL/pgSQL, PL/Perl, […]

Performance

Citus live query inspection using citus_stat_activity

by Hans-Jürgen Schönig | 11.2023

Most people who use PostgreSQL on a regular basis may have seen pg_stat_activity, which is a system view. It gives […]

How To

Connection Management in PostgreSQL - reserved_connections

by Hans-Jürgen Schönig | 11.2023

In PostgreSQL 16, a new feature has been added: reserved_connections. What is the idea behind it? Back in the old […]

How To

Kubernetes: Running the CYBERTEC PostgreSQL operator

by Hans-Jürgen Schönig | 11.2023

Kubernetes is a powerful and popular container orchestration platform that offers numerous benefits for organisations and developers. Many companies out […]

How To

Using multiple triggers on the same table in PostgreSQL

by Hans-Jürgen Schönig | 11.2023

“Developers, developers, developers, …” - let us not remind ourselves of this painful Microsoft presentation which was given by Mr […]

How To

kill -9 explained for PostgreSQL

by Hans-Jürgen Schönig | 11.2023

Do you want to kill a database connection? Or maybe you want to use kill -9? On your PostgreSQL database […]

How To

ERROR: current transaction is aborted in PostgreSQL

by Hans-Jürgen Schönig | 10.2023

Whenever you actively use transaction blocks in PostgreSQL “ERROR: current transaction is aborted, commands ignored until end of transaction block” […]

How To

1 2 3 … 29 Next »