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

Distributed aggregates / aggregate pushdown in PostgreSQL

by Hans-Jürgen Schönig | 10.2017
A feature from PostgreSQL 10 is related to Foreign Data Wrappers and is generally known as “aggregate pushdown”. Have a look!|

Visualizing data in PostgreSQL with R Shiny

by Hans-Jürgen Schönig | 09.2017
R is excellent for data analysis and graphics. Here's how to write an R application visualize data in a PostgreSQL database with R Shiny

Autovacuum wraparound protection in PostgreSQL

by Hans-Jürgen Schönig | 08.2017
Learn about one of the most misunderstood features in the PostgreSQL world: AUTOVACUUM and its “to prevent wraparound” notice.

Finding patterns in timeseries: A poor man's method

by Hans-Jürgen Schönig | 07.2017
UPDATED Aug 2023: Learn a trick in PostgreSQL timeseries analysis: Look for trends or known patterns in data - encode timeseries as strings.

Writing your own aggregation functions

by Hans-Jürgen Schönig | 07.2017
Database engines usually provide basic aggregate functions. This shows how to create your own code to calculate on the server side.

PostgreSQL: Indexes and foreign keys

by Hans-Jürgen Schönig | 07.2017
Missing indexes and foreign keys may cause database performance problems. Learn how to speed up things dramatically - not only in PostgreSQL!

Why favor PostgreSQL over MariaDB / MySQL

by Hans-Jürgen Schönig | 04.2017
For many years MySQL and PostgreSQL were competing databases, which addressed slightly different audiences. Why you should go for PostgreSQL!

Composite types in PostgreSQL: (func()).* - Hidden performance issues

by Hans-Jürgen Schönig | 04.2017
Using composite types offers db developers a great deal of flexibility. Passing complex data to functions is a lot easier.

Removing duplicate rows in PostgreSQL

by Hans-Jürgen Schönig | 04.2017
What if you accidently load data twice? How can developers handle duplicate data and cleanup things? | Removing duplicate rows.

Experimenting with scaling and full parallelism in PostgreSQL

by Hans-Jürgen Schönig | 02.2017
How-to about scaling PostgreSQL to one billion rows per second. We show you hands-on how to get the most out of your PostgreSQL server farms.
1 17 18 19 20 21 29
CYBERTEC Logo white
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