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: ltree vs. WITH RECURSIVE

by Hans-Jürgen Schönig | 06.2020
WITH RECURSIVE in PostgreSQL is efficient. However, ltree does have its strengths as well. Let us take a closer look. | Improve performance

SQL trickery: Hypothetical aggregates

by Hans-Jürgen Schönig | 06.2020
“If we had this data what would it mean?” - read more about this PostgreSQL technique, what it is good for & how it works.

Composite type performance issues in PostgreSQL

by Hans-Jürgen Schönig | 06.2020
Table functions & performance: Solve performance issues related to stored procedures and or a composite data type in PostgreSQL

PostgreSQL: Speeding up recursive queries and hierarchical data

by Hans-Jürgen Schönig | 06.2020
How to use a hierarchical query, which is an SQL query that handles model data such as the structure of organizations - find out more

SQL trickery: Configuring window functions

by Hans-Jürgen Schönig | 05.2020
How to use window functions and analytics - these have long been around in PostgreSQL and are widely used by advanced developers.

How to count hits on a website - concurrent counting in PostgreSQL

by Hans-Jürgen Schönig | 05.2020
How to grant users access to a certain piece of data a limited number of times. What happens if two users access it concurrently?

PostgreSQL: Network latency does make a BIG difference

by Hans-Jürgen Schönig | 05.2020
Find out about how network latency is essential to PostgreSQL database performance. Measure the performance impact caused by latency.

PostgreSQL: now() vs. 'NOW'::timestamp vs. clock_timestamp()

by Hans-Jürgen Schönig | 05.2020
How to use the PostgreSQL: now() vs. 'NOW'::timestamp vs. clock_timestamp() | Issues with time and date in PostgreSQL database applications

Speeding up count(*): Why not use max(id) - min(id)

by Hans-Jürgen Schönig | 04.2020
The usage of max(id) - min(id) to speed up count(*) may seem like a good approach when it comes to speeding up the process, but it can be problematic.

pg_show_plans: Watching execution plans in PostgreSQL LIVE

by Hans-Jürgen Schönig | 03.2020
pg_show_plans is an extension developed by CYBERTEC, which shows all active query plans in PostgreSQL | Execution plan live in PostgreSQL
1 10 11 12 13 14 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