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 it actually hold true?

VACUUM: Managing and detecting bloat

by Hans-Jürgen Schönig | 09.2024
We will explore the concept of VACUUM in PostgreSQL, its importance, and best practices for implementing effective vacuuming strategies.

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
In this blog we are talking about indexes. Speeding up index creation in PostgreSQL is one of the main topic.

Using AI to generate data structures for PostgreSQL

by Hans-Jürgen Schönig | 07.2024
In this blog I decided to show some insights into what can be done by using AI to generate data structures for PostgreSQL.

Foreign keys in PostgreSQL: Circular dependencies

by Hans-Jürgen Schönig | 06.2024
In this blog Hans-Jürgen Schönig would like to tell you more about "Foreign keys and circular dependencies".

PERFORMANCE TUNING: MAX AND GROUP BY

by Hans-Jürgen Schönig | 04.2024
Time series, time series analysis and alike. Unlock the potential of your Performance Tuning services. Find some tipps about how to.

Enforcing join orders in PostgreSQL

by Hans-Jürgen Schönig | 03.2024
PostgreSQL handle joins & especially join orders? Internally the PostgreSQL does a good job to optimize queries but how does it really work?

PostgreSQL: Why true Open Source matters

by Hans-Jürgen Schönig | 01.2024
Data oulives applications. Data matters. So does reliable and well maintained software as well. Read more about Open Source benefits.

Citus live query inspection using citus_stat_activity

by Hans-Jürgen Schönig | 11.2023
How to use citus_stat_activity to get all the the information about your database shards you need at once - makes it super easy to debug.
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