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

How to count hits on a website - concurrent counting in PostgreSQL

by Hans-Jürgen Schönig | 05.2020

Concurrent counting in PostgreSQL: Recently we covered “count” quite extensively in this blog. We discussed optimizing count(*) and also talked […]

How To

PostgreSQL: Network latency does make a BIG difference

by Hans-Jürgen Schönig | 05.2020

Database performance is truly important. However, when looking at performance in general people only consider the speed of SQL statements […]

Performance

PostgreSQL: now() vs. 'NOW'::timestamp vs. clock_timestamp()

by Hans-Jürgen Schönig | 05.2020

Everybody who has ever written any kind of database application had to use time and date. However, in PostgreSQL there […]

How To

Speeding up count(*): Why not use max(id) - min(id)

by Hans-Jürgen Schönig | 04.2020

Our PostgreSQL blog about “Speeding up count(*)” was widely read and discussed by our followers on the internet. We also […]

How To

pg_show_plans: Watching execution plans in PostgreSQL LIVE

by Hans-Jürgen Schönig | 03.2020

After 20 years in professional PostgreSQL support and consulting we are finally able to answer one of the most frequently […]

Performance

CLUSTER: Improving PostgreSQL performance

by Hans-Jürgen Schönig | 03.2020

When designing a database application, the layout of data in disk is often neglected. However, the way data is clustered […]

Performance

Reduce WAL by increasing checkpoint distance

by Hans-Jürgen Schönig | 03.2020

If you are running PostgreSQL in production you might have already noticed that adjusting checkpoints can be a very beneficial […]

Performance

shared_buffers: Looking into the PostgreSQL I/O cache

by Hans-Jürgen Schönig | 02.2020

The PostgreSQL caching system has always been a bit of a miracle to many people and many have asked me […]

How To & Performance

Migrating from MS SQL to PostgreSQL: Uppercase vs. Lowercase

by Hans-Jürgen Schönig | 02.2020

When migrating from MS SQL to PostgreSQL, one of the first things people notice is that in MS SQL, object […]

How To

pg_timetable: Advanced PostgreSQL scheduling

by Hans-Jürgen Schönig | 01.2020

UPDATED 14.02.2023: pg_timetable is a brand-new job scheduler for PostgreSQL implemented completely from scratch (in Go). Traditional job scheduling is […]

Performance