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

Regular expressions unleashed in PostgreSQL

by Hans-Jürgen Schönig | 04.2014

How to use an operator to work with regular expressions in PostgreSQL: includes list and a case-sensitive example. Fun with coding PostgreSQL

How To

Bypassing the transaction log

by Hans-Jürgen Schönig | 04.2014

When data is changed generally the change must be written to the xlog before it is written to the underlying table.

How To

wal_level: What is the difference?

by Hans-Jürgen Schönig | 03.2014

PostgreSQL replication requires changing the wal_level from “minimal” to “hot_standby”. What er the impacts? Read out more.

Performance

Logging - the hidden speedbrakes

by Hans-Jürgen Schönig | 03.2014

When it comes to performance, people tend to forget some basic topics entirely. One of those topics is the impact of writing log files.

Performance

max_connections - Performance impacts

by Hans-Jürgen Schönig | 03.2014

Setting max_connections to an insanely high value is not good for performance. I tried it, to see what impact it has in PostgreSQL.

Performance

Adjusting maintenance_work_mem

by Hans-Jürgen Schönig | 02.2014

After testing shared_buffers recently, I decided to do a little more testing on our new office desktop PC (8 core […]

Performance

PostgreSQL 9.3 - Shared Buffers Performance (1)

by Hans-Jürgen Schönig | 02.2014

A lot has been said about PostgreSQL shared buffers and performance. As my new desktop box has arrived this week […]

News & Performance

Detecting fraud: Benford's law

by Hans-Jürgen Schönig | 01.2014

Benford's law is a mechanism, which is widely used in many fields. Especially accounting fraud can be detected nicely using this simple law of mathematics.

How To