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: GROUP BY expression

by Hans-Jürgen Schönig | 08.2020
GROUP BY is nothing new and is available in any relational database I am aware of. It is an integral […]

effective_cache_size: A practical example

by Hans-Jürgen Schönig | 07.2020
A lot has been written about effective_cache_size in postgresql.conf and about PostgreSQL performance in general. However, few people know what […]

PostgreSQL: More performance for LIKE and ILIKE statements

by Hans-Jürgen Schönig | 07.2020
LIKE and ILIKE are two fundamental SQL features. People use those things all over the place in their application and […]

PostgreSQL: Useful new data types - CREATE DOMAIN

by Hans-Jürgen Schönig | 07.2020
UPDATED 08.05.2023 - SQL and especially PostgreSQL provide a nice set of general purpose data types you can use to […]

Calculating differences between rows in SQL

by Hans-Jürgen Schönig | 06.2020
Recently we had some clients who had the desire to store timeseries in PostgreSQL. One of the questions which interested […]

PostgreSQL: ltree vs. WITH RECURSIVE

by Hans-Jürgen Schönig | 06.2020
After my last post about ltree and recursive data in PostgreSQL people have asked me privately about performance issues. To […]

SQL trickery: Hypothetical aggregates

by Hans-Jürgen Schönig | 06.2020
“If we had this data what would it mean?” - these kinds of questions can be answered using plain SQL. […]

Composite type performance issues in PostgreSQL

by Hans-Jürgen Schönig | 06.2020
This blog is about table functions and performance. PostgreSQL is a really powerful database and offers many features to make […]

PostgreSQL: Speeding up recursive queries and hierarchical data

by Hans-Jürgen Schönig | 06.2020
A hierarchical query is an SQL query that handles hierarchical model data such as the structure of organizations, living species, […]

SQL trickery: Configuring window functions

by Hans-Jürgen Schönig | 05.2020
Generating simple data sets Before we get started, I want to introduce my favorite set-returning functions which can help you […]
1 … 9 10 11 12 13 … 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