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

VACUUM does not shrink my PostgreSQL table

by Hans-Jürgen Schönig | 10.2022
Did you ever wonder why VACUUM does not shrink PostgreSQL data files? Learn all the most useful secrets of VACUUM.

LISTEN / NOTIFY: Automatic client notification in PostgreSQL

by Hans-Jürgen Schönig | 09.2022
If 1000's of users constantly poll the database, a lot of load is caused for no benefit. LISTEN / NOTIFY is a better way, find out how.

PostgreSQL: Sequences vs. Invoice numbers

by Hans-Jürgen Schönig | 09.2022
What's the problem with using PostgreSQL database side sequences to create unique invoice numbers to send to clients? Let's find out.

What is an inner join in SQL? And what is an outer join?

by Hans-Jürgen Schönig | 09.2022
Joins: Learn how to use an inner join and an outer join in PostgreSQL today by reading our tutorial. Also covers semi and full joins.

ERROR: nextval: reached maximum value of sequence

by Hans-Jürgen Schönig | 09.2022
Fix "ERROR: nextval: reached maximum value of sequence in PostgreSQL" - related to using serial data type to generate auto-increment columns

ALTER TABLE ... ADD COLUMN … done right in PostgreSQL

by Hans-Jürgen Schönig | 08.2022
Running ALTER TABLE … ADD COLUMN can cause serious issues in production. Understand how to cleanly change PostgreSQL data structures.

Column order in PostgreSQL does matter

by Hans-Jürgen Schönig | 07.2022
Column order can determine how quickly your data is processed in PostgreSQL. Find out how to troubleshoot performance problems in wide tables

Handling Bonus Programs in SQL

by Hans-Jürgen Schönig | 07.2022
Learn how to address the issue of bonus programs in SQL, improve your understanding of PostgreSQL, and calculate bonus points efficiently

PostgreSQL 15: Using MERGE in SQL

by Hans-Jürgen Schönig | 05.2022
Merge - UPDATED 2023 - a technical preview of how to merge lists with ease. Find out about a wonderful command - add power to your PostgreSQL.

Find and fix a missing PostgreSQL Index

by Hans-Jürgen Schönig | 04.2022
Explains how to find a missing Postgresql index, what you can do to fix missing indexes, and how to achieve good database performance.
1 … 3 4 5 6 7 … 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