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

Migrating from Oracle: One word about pg_type

by Hans-Jürgen Schönig | 04.2016
Here is some pg_type related trickery, which might be entertaining. A workaround for porting the pg_type table from Oracle to PostgreSQL.

Registering PostgreSQL as a service on Windows with pg_ctl

by Hans-Jürgen Schönig | 04.2016
If you happen to run Windows, pg_ctl provides a nice way to register a PostgreSQL service. We show you how to do it right.

VirtualBox vs. hardware for PostgreSQL

by Hans-Jürgen Schönig | 02.2016
Is there really a performance difference in PostgreSQL on hardware and PostgreSQL on Virtualbox? Find out here.

pg_service.conf: The forgotten config file

by Hans-Jürgen Schönig | 02.2016
Configure services in a config file: pg_service.conf, and address them without having to worry about host, port, user and so on.

Permissions: A little trickery

by Hans-Jürgen Schönig | 12.2015
Learn how to use the INHERIT keyword in PostgreSQL, which allows a role to inherit permissions from another role. There is a catch, however.

Join pruning - Cool stuff in PostgreSQL

by Hans-Jürgen Schönig | 12.2015
UPDATED 2023: Find out how the PostgreSQL optimizer decides about “join pruning”. Improve performance, provide end users with simpler plans.

Producing LaTeX output

by Hans-Jürgen Schönig | 12.2015
By coincidence I noticed that psql can produce perfect LaTeX code. How cool is that? We show you how to do it, with examples.

Flexible grouping: Some dirty SQL trickery

by Hans-Jürgen Schönig | 11.2015
How to group PostgreSQL data with some dirty SQL trickery. Find the difference between timestamps; how to use flexible grouping.

Indexing Wikipedia

by Hans-Jürgen Schönig | 10.2015
Indexing Wikipedia with PostgreSQL | The goal is to see which settings are most suitable for the creation of a GIN index.

pg_stat_statements: The way I like it

by Hans-Jürgen Schönig | 10.2015
Finding slow queries using the PostgreSQL extension pg_stat_statements. Improve your database performance and monitoring.
1 … 19 20 21 22 23 … 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