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

Speeding up GROUP BY in PostgreSQL

by Hans-Jürgen Schönig | 03.2019
How to speed up GROUP BY statements in PostgreSQL. Follow some basic rules & you will squeeze performance out of the database for free.

Foreign data wrapper for PostgreSQL: Performance Tuning

by Hans-Jürgen Schönig | 03.2019
fdw performance tuning - hidden tuning options which are not widely known. Let's see how to speed up the PostgreSQL foreign data wrapper.

unaccent: Getting rid of umlauts, accents and special characters

by Hans-Jürgen Schönig | 03.2019
Unaccent is a useful PostgreSQL extension for improving user experience. Get insight into this extension and its purpose.

Implementing “AS OF”-queries in PostgreSQL

by Hans-Jürgen Schönig | 02.2019
Many databases such as Oracle provide "AS OF" queries (timetravel). This blog explains how to do time travel in PostgreSQL.

pg_permissions: Inspecting your PostgreSQL security system

by Hans-Jürgen Schönig | 01.2019
pg_permissions is a tool display the security settings of your database. Get a quick overview of what's going on inside your security.

A PostgreSQL story about "NULL IS NULL = NULL AND NOT NULL"

by Hans-Jürgen Schönig | 12.2018
Why the word "unknown" is better to describe a NULL value than "empty". Learn to use NULL values correctly in PostgreSQL.

Transactions in PostgreSQL: READ COMMITTED vs. REPEATABLE READ

by Hans-Jürgen Schönig | 11.2018
How to use the two most common transaction isolation levels in PostgreSQL: READ COMMITTED and REPEATABLE READ.

PostgreSQL: Implicit vs. explicit joins

by Hans-Jürgen Schönig | 11.2018
How to use implicit and explicit joins in PostgreSQL. What are the performance differences between these two types of join?

PostgreSQL: Parallel CREATE INDEX for better performance

by Hans-Jürgen Schönig | 09.2018
How to use parallel CREATE INDEX in PostgreSQL, which will eliminate various performance bottlenecks - especially for large applications.

What hot_standby_feedback in PostgreSQL really does

by Hans-Jürgen Schönig | 08.2018
How to avoid streaming replication conflicts with hot_standby_feedback and VACUUM. Improve your replication setup and prevent failure.
1 … 13 14 15 16 17 … 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