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

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.

How To & Performance

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...

How To

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.

Performance

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.

Performance

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.

How To

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?

How To