CYBERTEC PostgreSQL Logo
Ants Aasma Profile Picture

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

Why "SELECT * FROM table" is NOT a read

by Hans-Jürgen Schönig | 09.2024
People tend to think that a SELECT-operation is always a read. This might look obvious and make sense but does […]

VACUUM: Managing and detecting bloat

by Hans-Jürgen Schönig | 09.2024
In this introduction, we will explore the concept of VACUUM in PostgreSQL, its importance, and best practices for implementing effective […]

Enhanced security: Logging PostgreSQL connections

by Hans-Jürgen Schönig | 08.2024
Logging connections in PostgreSQL can be incredibly valuable for monitoring and troubleshooting purposes. However,  that’s not all: auditing is also […]

Speeding up index creation in PostgreSQL

by Hans-Jürgen Schönig | 07.2024
Indexes are, by far, the most important feature related to performance that every general purpose relational database provides. Without indexes, […]

Using AI to generate data structures for PostgreSQL

by Hans-Jürgen Schönig | 07.2024
Artificial Intelligence is the motto of the day. Everybody is talking about it, everybody seems to know what it means […]

Foreign keys in PostgreSQL: Circular dependencies

by Hans-Jürgen Schönig | 06.2024
Relational databases provide one very essential functionality which is key to integrity, data quality and consistency: foreign keys. If you […]

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 […]

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 […]

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 […]

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 […]
1 2 3 29
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram