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

Naming temporary tables properly in PostgreSQL

by Hans-Jürgen Schönig | 06.2015
What if a temporary table in PostgreSQL has the same name as a “real” table? What happens? Find out about naming temporary tables properly.

DROP TABLE: Killing shared_buffers

by Hans-Jürgen Schönig | 06.2015
UPDATED August 2023: How to tune shared buffers - when it is large, PostgreSQL performance issues may result: what to do to fix the problem.

PostgreSQL 9.4 aggregate filter clauses: They do pay off

by Hans-Jürgen Schönig | 02.2015
In this blog ppost we cover the impact of aggregate FILTER clauses have on performance. Find out more about aggregation filters.

Partial aggregation: The beautiful way

by Hans-Jürgen Schönig | 02.2015
Partial aggregation: Functions such as min, max, count, sum, avg and so on are used in virtually every application. Find out more.

Managing backup speed with pg_basebackup

by Hans-Jürgen Schönig | 01.2015
How to adjust backup speed when using pg_basebackup in PostgreSQL. What if the I/O capacity of servers is low & network bandwidth is large?

Analytics: Lagging entire rows

by Hans-Jürgen Schönig | 10.2014
There is a PostgreSQL feature in the area of analytics which is not widely known: the power to use composite data types along with analytics.

walbouncer: Filtering the transaction log

by Hans-Jürgen Schönig | 10.2014
You might not want to replicate all data to your standbys. walbouncer can filter the transaction log, & replicate only the data needed.

Killing proper indexing: A neat idea

by Hans-Jürgen Schönig | 10.2014
There are a couple of ways to kill indexing entirely. One of this ways is to apply functions or expressions. Read out in our blog.

Next stop: Joining 1 million tables

by Hans-Jürgen Schönig | 09.2014
This week I started my preparations for one of my talks in Madrid. The topic is: "Joining 1 million tables". […]

Checking per-memory context memory consumption

by Hans-Jürgen Schönig | 09.2014
Internally PostgreSQL makes use of so called “memory contexts”. What is the idea and what are the advantages? Find out here.
1 … 21 22 23 24 25 … 29
CYBERTEC Logo white
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.

    ©
    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