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

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.

How the PostgreSQL query optimizer works

by Hans-Jürgen Schönig | 03.2021
Get insight into how the PostgreSQL optimizer works and how it speeds up queries. Find out about anti-join & from_collapse_limit.

Setting up SSL authentication for PostgreSQL

by Hans-Jürgen Schönig | 03.2021
How to set up SSL authentication for PostgreSQL. Handle secure client server connections in the best possible way.
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.

    ©
    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