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

Scaling PostgreSQL: Using more than just one core for aggregation

by Hans-Jürgen Schönig | 09.2015
Unfortunately PostgreSQL cannot scale a single query to more than one core. We have done some experiments to see how scaling up can work.

pgstrom: PostgreSQL on a GPU with joins

by Hans-Jürgen Schönig | 09.2015
Test of performance using pgstrom with joins in PostgreSQL. Find out how pgstrom performs under different join conditions.

pgstrom: Checking GPU performance

by Hans-Jürgen Schönig | 09.2015
A more extensive look at pgstrom (a module to make use of GPUs for PostgreSQL). I was excited to see the first real performance data.

Testing GPU-accelerated PostgreSQL

by Hans-Jürgen Schönig | 09.2015
Some important work is also going into the PGStrom project, which is all about bringing the power of modern GPUs to PostgreSQL

Fuzzy search unleashed

by Hans-Jürgen Schönig | 08.2015
Fuzzy search solves the problem of spelling errors in searches. The goal is really to make sure that users have a chance - even with typos.

Turning xlog into JSON

by Hans-Jürgen Schönig | 08.2015
JSON is used for configuration, data transfer, and a lot more. Luckily PostgreSQL is pretty good at it. Turn xlog into JSON.

SKIP LOCKED: Locking for maximum concurrency

by Hans-Jürgen Schönig | 07.2015
Many cool new features have been added to the wonderful PostgreSQL 9.5 release. One of the most exciting ones is definitely SKIP LOCKED.

Transactional DDLs

by Hans-Jürgen Schönig | 07.2015
In PostgreSQL all major DDLs (CREATE TABLE, ...) are fully transactional. However, there are some exceptions.

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.
1 … 20 21 22 23 24 … 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.

    ©
    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