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

Citus: 7 commonly used advanced SQL tools

by Hans-Jürgen Schönig | 09.2023
When you run advanced SQL in Citus, what's possible? Which SQL statements work, and which ones don't? Citus is a […]

Citus: Row store vs. column store in PostgreSQL

by Hans-Jürgen Schönig | 09.2023
Row store vs. column store - a lot has been written about this topic in the context of PostgreSQL and […]

"hired" vs. "fired" - fuzzy search in PostgreSQL

by Hans-Jürgen Schönig | 09.2023
When dealing with data (and life in general) small things can have a major impact. The difference between “hired” and […]

Data locality: Scaling PostgreSQL with Citus intelligently

by Hans-Jürgen Schönig | 09.2023
While sharding is often advertised as “THE solution to PostgreSQL scalability”, it is necessary to keep some technical aspects in […]

Monitoring PostgreSQL replication

by Hans-Jürgen Schönig | 09.2023
PostgreSQL replication is not just a way to scale your database to run ever larger workloads: it's also a way […]

Citus: Sharding your first table

by Hans-Jürgen Schönig | 09.2023
Citus is a capable sharding solution for PostgreSQL. It solves a ton of scalability issues: these can be addressed using […]

Killing performance with PostgreSQL partitioning

by Hans-Jürgen Schönig | 07.2023
PostgreSQL is a powerful database which supports partitioning. In contrast to Oracle partitioning is part of the PostgreSQL core engine […]

What is a schema in PostgreSQL?

by Hans-Jürgen Schönig | 06.2023
One way to organize data in PostgreSQL is to make use of schemas. What is a schema in PostgreSQL? And […]

PostgreSQL: DELETE vs. TRUNCATE

by Hans-Jürgen Schönig | 03.2023
Data isn't only about storage and accumulation - sometimes it's also about deletion, cleanup and archiving. In SQL there's more […]

PostgREST: Get started with automated PostgreSQL APIs

by Hans-Jürgen Schönig | 03.2023
This blog introduces you to PostgREST and helps you to get started with it quickly. What is PostgREST? First think […]
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