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

ERROR: current transaction is aborted in PostgreSQL

by Hans-Jürgen Schönig | 10.2023
Whenever you actively use transaction blocks in PostgreSQL “ERROR: current transaction is aborted, commands ignored until end of transaction block” […]

Kill long running queries in PostgreSQL

by Hans-Jürgen Schönig | 10.2023
How to terminate long running queries in PostgreSQL: People might be fans of SQL, people might like PostgreSQL on Kubernetes […]

pg_resetwal: When to reset the WAL in PostgreSQL

by Hans-Jürgen Schönig | 10.2023
pg_resetwal (formerly known as pg_resetxlog) is a command provided by PostgreSQL which allows you to reset the WAL (Write Ahead […]

Migrate from Sybase to PostgreSQL

by Hans-Jürgen Schönig | 10.2023
In 1987, Sybase Adaptive Server Enterprise (Sybase ASE, now SAP ASE) was released to the public, and was adopted by […]

pg_stat_io and PostgreSQL 16 performance

by Hans-Jürgen Schönig | 10.2023
Learn about pg_stat_io's debugging power: PostgreSQL 16 blesses users around the world with many features which ensure an even better […]

Monitoring Performance for PostgreSQL with Citus

by Hans-Jürgen Schönig | 09.2023
In the fast-paced world of data management, scalability rules supreme and Citus plays an ever greater role. The question now […]

Citus: 7 commonly used advanced SQL tools

by Hans-Jürgen Schönig | 09.2023
When you run advanced SQL in Citus, what's possible? Which SQL statements work, and which ones don't? Citus is a […]

Citus: Row store vs. column store in PostgreSQL

by Hans-Jürgen Schönig | 09.2023
Row store vs. column store - a lot has been written about this topic in the context of PostgreSQL and […]

"hired" vs. "fired" - fuzzy search in PostgreSQL

by Hans-Jürgen Schönig | 09.2023
When dealing with data (and life in general) small things can have a major impact. The difference between “hired” and […]

Data locality: Scaling PostgreSQL with Citus intelligently

by Hans-Jürgen Schönig | 09.2023
While sharding is often advertised as “THE solution to PostgreSQL scalability”, it is necessary to keep some technical aspects in […]
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf

+43 (0) 2622 93022-0

Get the newest PostgreSQL Info & Tools

    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    CYBERTEC PostgreSQL International GmbH
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram