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

Detect PostgreSQL performance problems easily

by Hans-Jürgen Schönig | 02.2018
Every DBA in charge of PostgreSQL should know, how to track down potential performance problems to figure out, what is really going on.

PostgreSQL indexing: Index scan vs. Bitmap scan vs. Sequential scan (basics)

by Hans-Jürgen Schönig | 02.2018
Introduction to PostgreSQL indexing. How and when to use an index scan, bitmap scan and/or sequential scan. Get performance tips.

Avoiding unnecessary function calls in PostgreSQL

by Hans-Jürgen Schönig | 01.2018
Fix bad performance related to slow function calls: When it comes to slow procedures, PostgreSQL often isn't to blame. Here's why.

CYBERTEC pgconfigurator: Configuring PostgreSQL visually

by Hans-Jürgen Schönig | 01.2018
CYBERTEC pgconfigurator is the ideal tool to configure postgresql.conf visually. PostgreSQL configuration has never been easier.

Preparing data for machine learning in PostgreSQL

by Hans-Jürgen Schönig | 01.2018
Most of the code related to machine learning available today is overloaded. Why not prepare the data in SQL? It's easier & more flexible.

ALTER TABLE: High-Availability taken care of

by Hans-Jürgen Schönig | 01.2018
Adding columns, dropping columns,... might be necessary. But changing data structures should not be done mindlessly. Use ALTER TABLE wisely.

PostgreSQL: Speeding up GROUP BY and joins

by Hans-Jürgen Schönig | 12.2017
Most people actually implement aggregations slightly wrong in PostgreSQL. This blogpost shows how to spped up group by and joins.

Creating 1 million users in PostgreSQL

by Hans-Jürgen Schönig | 12.2017
“How many users can you have in PostgreSQL?” - “Well, as many as you want.” Here's how to easily create a large number of database users.

Searching for the best compromise: “Skyline” queries

by Hans-Jürgen Schönig | 12.2017
What about making more intelligent queries in PostgreSQL? Skyline queries could be the answer for you. We show you how to set them up.

pg_crash: Making database crashes great again

by Hans-Jürgen Schönig | 11.2017
pg_crash is the ultimate tool to stress test your PostgreSQL database and infrastructure as well as your high-availability infrastructure.
1 16 17 18 19 20 29
CYBERTEC Logo white
Get the newest PostgreSQL Info & Tools


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

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