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

Partial aggregation: The beautiful way

by Hans-Jürgen Schönig | 02.2015
Partial aggregation: Aggregations are a fundamental feature of SQL. Functions such as min, max, count, sum, avg and so on […]

Managing backup speed with pg_basebackup

by Hans-Jürgen Schönig | 01.2015
pg_basebackup and backup speed: In the past couple of years, replication has been made easier and easier. Setting up streaming […]

Analytics: Lagging entire rows

by Hans-Jürgen Schönig | 10.2014
PostgreSQL has offered support for powerful analytics and window functions for a couple of years now. Many people all around […]

walbouncer: Filtering the transaction log

by Hans-Jürgen Schönig | 10.2014
Up until now, it was only possible to replicate entire database instances from one node to the other. A standby […]

Killing proper indexing: A neat idea

by Hans-Jürgen Schönig | 10.2014
After being on the road to do PostgreSQL consulting for CYBERTEC for over a decade I noticed that there are […]

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
Writing a complex database server like PostgreSQL is not an easy task. Especially memory management is an important task, which […]

Shrink the storage footprint of PostgreSQL data

by Hans-Jürgen Schönig | 08.2014
When writing data structures and table layouts, people usually don't care about the order of columns. Why should they anyway? […]

pg_resetxlog: renamed to pg_resetwal

by Hans-Jürgen Schönig | 08.2014
UPDATE September 2023: This feature is now called pg_resetwal, see the PostgreSQL documentation about it here. The blog below will […]

Code size over time

by Hans-Jürgen Schönig | 08.2014
With PostgreSQL 9.4 just around the corner and 8.4 just retired I thought it is time to review those years […]
1 … 21 22 23 24 25 … 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