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

Preparing data for machine learning in PostgreSQL

by Hans-Jürgen Schönig | 01.2018
Most of the code related to machine learning available today is overloaded. Why not prepare the data in SQL? It's easier & more flexible.

ALTER TABLE: High-Availability taken care of

by Hans-Jürgen Schönig | 01.2018
Adding columns, dropping columns,... might be necessary. But changing data structures should not be done mindlessly. Use ALTER TABLE wisely.

PostgreSQL: Speeding up GROUP BY and joins

by Hans-Jürgen Schönig | 12.2017
Most people actually implement aggregations slightly wrong in PostgreSQL. This blogpost shows how to spped up group by and joins.

Creating 1 million users in PostgreSQL

by Hans-Jürgen Schönig | 12.2017
“How many users can you have in PostgreSQL?” - “Well, as many as you want.” Here's how to easily create a large number of database users.

Searching for the best compromise: “Skyline” queries

by Hans-Jürgen Schönig | 12.2017
What about making more intelligent queries in PostgreSQL? Skyline queries could be the answer for you. We show you how to set them up.

pg_crash: Making database crashes great again

by Hans-Jürgen Schönig | 11.2017
pg_crash is the ultimate tool to stress test your PostgreSQL database and infrastructure as well as your high-availability infrastructure.

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.
1 … 16 17 18 19 20 … 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