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

Speed up PostgreSQL data loading with COPY (FREEZE)

by Hans-Jürgen Schönig | 08.2014
UPDATED JULY 19, 2023 - When I do training here at CYBERTEC, people often ask how to load data fast […]

Speeding up things with hint bits

by Hans-Jürgen Schönig | 08.2014
Post UPDATED June 2023: PostgreSQL is a highly sophisticated relational database system capable of performing wonderful operations. But, sophistication also […]

Optimization issues: Cross column correlation

by Hans-Jürgen Schönig | 07.2014
UPDATE Sept. 2023: For more recent information about planner statistics, see the PostgreSQL documentation about extended statistics, or this blog […]

Detecting wrong planner estimates

by Hans-Jürgen Schönig | 07.2014
In 99% of all cases the PostgreSQL planner does a perfect job to optimize your queries and to make sure […]

Reducing log messages on the client

by Hans-Jürgen Schönig | 06.2014
It happens quite frequently that PostgreSQL client applications are flooded with messages from the server. This is both annoying and […]

CREATE CAST: Casting integer to IP in PostgreSQL

by Hans-Jürgen Schönig | 05.2014
Once in a while, you have to juggle around with IP addresses and store them / process them in an […]

The power of response times and execution time

by Hans-Jürgen Schönig | 04.2014
The goal of the PostgreSQL optimizer is to provide you with a plan, which executes as fast as possible and […]

Regular expressions unleashed in PostgreSQL

by Hans-Jürgen Schönig | 04.2014
When cleaning up some old paperwork this weekend I stumbled over a very old tutorial on regular expressions. In fact, […]

Bypassing the transaction log

by Hans-Jürgen Schönig | 04.2014
Referring to my previous blog post about the amount of xlog written by PostgreSQL I wanted to clarify what I […]

wal_level: What is the difference?

by Hans-Jürgen Schönig | 03.2014
To use PostgreSQL replication it is necessary to change the wal_level from “minimal” to “hot_standby”. But, which impact does this […]
1 … 22 23 24 25 26 … 29
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


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

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