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

CLUSTER: Improving PostgreSQL performance

by Hans-Jürgen Schönig | 03.2020
Learn an important trick to lower the performance impact of data storage methods in your PostgreSQL database. Use CLUSTER to improve speed.

Reduce WAL by increasing checkpoint distance

by Hans-Jürgen Schönig | 03.2020
Adjusting checkpoints is useful when tuning a server and improves the database performance. Furthermore, it helps to reduce WAL.

shared_buffers: Looking into the PostgreSQL I/O cache

by Hans-Jürgen Schönig | 02.2020
shared_buffers: What does the PostgreSQL I/O cache contain? Find out what the cache knows about your database.

Migrating from MS SQL to PostgreSQL: Uppercase vs. Lowercase

by Hans-Jürgen Schönig | 02.2020
How to: MS SQL PostgreSQL Migration. What you should do and how you can do it easily. Read more in this blog...

pg_timetable: Advanced PostgreSQL scheduling

by Hans-Jürgen Schönig | 01.2020
How to get the best PostgreSQL job scheduling: pg_timetable provides better job execution in than other schedulers. Read the details.

PostgreSQL: You might need to increase max_locks_per_transaction

by Hans-Jürgen Schönig | 01.2020
How can you prevent the error "out of shared memory" in PostgreSQL? max_locks_per_transaction is the critical configuration parameter.

Setting PostgreSQL configuration parameters

by Hans-Jürgen Schönig | 12.2019
PostgreSQL configuration offers more than meets the eye at first glance, so let us dive into PostgreSQL configuration parameters.

Abusing PostgreSQL as an SQL beautifier

by Hans-Jürgen Schönig | 12.2019
Even though SQL is pretty easy to read, developers often use SQL beautifier. Is it possible to format queries nicely only using PostgreSQL onboard tools?

effective_cache_size: What it means in PostgreSQL

by Hans-Jürgen Schönig | 11.2019
effective_cache_size is usefull for database tuning as well als for speeding up PostgreSQL. Learn more about of this secretive setting.

Prewarming PostgreSQL I/O caches

by Hans-Jürgen Schönig | 10.2019
How to deal with PostgreSQL restarts? pg_prewarm allows you to automatically prewarm your caches after a database failure or a simple restart
1 11 12 13 14 15 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