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

Data warehousing: Making use of synchronized seq scans

by Hans-Jürgen Schönig | 06.2021
Did you know PostgreSQL has the ability to synchronize sequential scans? If you are running data warehouses, you might have already used it without knowing.

Enabling and disabling autovacuum in PostgreSQL

by Hans-Jürgen Schönig | 06.2021
UPDATED Aug 2023: How to enable and disable autovacuum in PostgreSQL: How does autovacuum really work? Can you simply turn it on and off?

PostgreSQL: Bulk loading huge amounts of data

by Hans-Jürgen Schönig | 05.2021
This article is about bulk loading, which is the quickest way to import large amounts of data into a PostgreSQL database.

PostgreSQL: Detecting slow queries quickly

by Hans-Jürgen Schönig | 05.2021
UPDATED Mar 2023: How to use pg_stat_statements to detect slow queries - including examples and code - improve PostgreSQL performance

Setting up PostgreSQL streaming replication

by Hans-Jürgen Schönig | 05.2021
This tutorial will show you how to setup up and configure streaming replication for PostgreSQL 13 & how to set up database servers quickly.

Terminating database connections in PostgreSQL

by Hans-Jürgen Schönig | 05.2021
This blog posting explains you, how to terminate queries and database connections in PostgreSQL. Find out more.

PostgreSQL: Understanding deadlocks

by Hans-Jürgen Schönig | 04.2021
"ERROR: deadlock detected" - message - what should I do? This article explains what this really means and how deadlocks can be prevented.

Cleaning up a large number of BLOBs in PostgreSQL

by Hans-Jürgen Schönig | 04.2021
Basically, there are two ways to delete BLOBs (binary large objects):Change the PostgreSQL configuration or delete the BLOBs in chunks.

Getting started with QGIS, PostgreSQL and PostGIS

by Hans-Jürgen Schönig | 04.2021
Visualizing spatial data is an important task. This tutorial helps you with getting started with visualizing OSM data with PostGIS and QGIS.

PostgreSQL: Get member roles and permissions

by Hans-Jürgen Schönig | 04.2021
PostgreSQL allows you to define users (=roles), groups, etc. This post explains how to retrieve information on roles & role membership.
1 … 6 7 8 9 10 … 29
CYBERTEC Logo white
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.

    ©
    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