CYBERTEC 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

Partition PostgreSQL: which partition did I INSERT my data into?

by Hans-Jürgen Schönig | 11.2022
Partitioning is one of the most desired features of PostgreSQL, widely adopted by developers. This is not only true for […]

PostgreSQL ERROR: permission denied for schema public

by Hans-Jürgen Schönig | 11.2022
In PostgreSQL 15, a fundamental change took place which is relevant to every user who happens to work with permissions: […]

btree vs. BRIN: 2 options for indexing in PostgreSQL data warehouses

by Hans-Jürgen Schönig | 11.2022
Indexing is the key to good performance. However, people often ask: Is there an alternative to btree indexing? Can we […]

pgbouncer: Types of PostgreSQL connection pooling

by Hans-Jürgen Schönig | 10.2022
pgbouncer is one of the most widely used tool for connection pooling. At CYBERTEC, we've successfully deployed it in many […]

VACUUM does not shrink my PostgreSQL table

by Hans-Jürgen Schönig | 10.2022
Did you ever wonder why VACUUM does not make your PostgreSQL tables smaller? Did you ever wonder why VACUUM does […]

LISTEN / NOTIFY: Automatic client notification in PostgreSQL

by Hans-Jürgen Schönig | 09.2022
What is LISTEN and NOTIFY? LISTEN / NOTIFY is a feature that enables users to listen to what goes on […]

PostgreSQL: Sequences vs. Invoice numbers

by Hans-Jürgen Schönig | 09.2022
Sequences are a core feature of SQL. However, some users are tempted to implement sequences to generate invoices. That's dangerous […]

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

by Hans-Jürgen Schönig | 09.2022
A join is a concept in IT which is widely used and often referred to but rarely really understood. What […]

ERROR: nextval: reached maximum value of sequence

by Hans-Jürgen Schönig | 09.2022
serial is a popular pseudo data type in PostgreSQL which is often used to generate auto-increment columns. However, this can […]

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

by Hans-Jürgen Schönig | 08.2022
Running ALTER TABLE … ADD COLUMN can have side effects which have the potential to cause serious issues in production. […]
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

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