About

Hans-Jürgen Schönig has been a PostgreSQL expert and database specialist since the 90s. He is CEO and technical lead of CYBERTEC, which is one of the database market leaders worldwide and has served countless customers around the globe since the year 2000.As CEO of CYBERTEC, Hans-Jürgen Schönig regularly advises customers in database services and creates individual concepts tailored to each client’s needs. Additionally, he regularly gives training on PostgreSQL Advanced Optimization & Performance Tuning, PostgreSQL for Business Intelligence and Mass Data Analysis, PostgreSQL Replication Professional and Linux for PostgreSQL DBAs - just to name a few.


    Hans-Jürgen Schönig pg_timetable: PostgreSQL scheduling done right
    Scheduling on steroids

    presented by Hans-Jürgen Schönig

    Many schedulers for PostgreSQL have come and gone. When pg_timetable was developed we tried to learn from past mistakes and build a scheduler that is powerful and which can last. It offers every feature needed in the real world and offers a new approach to scheduling in PostgreSQL. Let us dive in and find out what it can do to provide an even better user experience.

    Tue 5 2021 Development
    Hans-Jürgen Schönig CYPEX: Revolutionizing PostgreSQL Application Development

    presented by Hans-Jürgen Schönig


    video

    CYPEX is a user-friendly tool to quickly build PostgreSQL applications. Little coding is needed to achieve big results – which makes it one of the fastest development tools for PostgreSQL. Traditional application development has taken a lot of precious time which is not feasible anymore. Empower professional developers and enable everyone else in your organization to be a part of the solut...

    more

    Tue 10 2020 Dev
    Hans-Jürgen Schönig PostgreSQL performance from the ground up
    Because database speed matters

    presented by Hans-Jürgen Schönig

    Are you facing performance problems? Well, if you do this is the perfect training class for you. You will be guided through PostgreSQL performance from the ground up and learn how to optimize your PostgreSQL database to achieve maximum performance under all circumstances. We will also point you to the most common bottlenecks and provide easy solutions to those problems.

    Ops and Administration
    Hans-Jürgen Schönig PostgreSQL TDE: Fully encrypted PostgreSQL
    Building more secure databases

    presented by Hans-Jürgen Schönig

    PostgreSQL TDE is a version of PostgreSQL which fully supports "Data At Rest Encryption". All data will be encrypted on disk and therefore PostgreSQL TDE offers additional layers of security which can hardly be achieved with standard PostgreSQL. PostgreSQL TDE is Open Source and can be used free of charge. You will learn how it works and what can be achieved at which kind of performance impac...

    more

    Ops and Administration
    Hans-Jürgen Schönig Nov 21st 9:00AM EST: Postgres + Kubernetes: yes it really is a match made in heaven

    presented by Hans-Jürgen Schönig

    Kubernetes is a great place to run many services that requires automatisation and scale. By running Postgresql database on Kubernetes one can create uniformly managed, claud-native deployments with the flexibility to deploy postgresql as a service. Operator allows you to provide additional cotext to manage stateful application. An Operator also helps us with actions including provisioning...

    more

    Hans-Jürgen Schönig An introduction to PostgreSQL security

    presented by Hans-Jürgen Schönig

    PostgreSQL security is an important topic and the database offers a variety of features to protect your data. This training will teach you security from the ground up and cover aspects such as network security, authentication, database side permissions, row level security, security barriers as well as some additional tooling. At the end of the day you will be able to configure and manage a pro...

    more

    Wed 9 2019 Ops and Administration
    Hans-Jürgen Schönig Finding and fixing slow queries

    presented by Hans-Jürgen Schönig

    Your database is performing badly but you got no idea why. Fortunately PostgreSQL has all the means to figure out what is really going on inside your database. You just have to find the right modules and use the right tools and understand what PostgreSQL is really trying to tell you. This talk will show you how to track down slow queries using pg_stat_statement, work with "explain analyze" and...

    more

    Wed 9 2019 Ops and Administration
    Hans-Jürgen Schönig PostgreSQL performance in 5 minutes
    Speeding up your database

    presented by Hans-Jürgen Schönig

    Are you suffering from bad performance? Is your database slow and does not satisfy your needs? In this case you should consider using a standard approach to improving performance. During this talk you will learn how to tune your database, detect bottlenecks and to find the most common problems. Find out how to speed up your system and learn all about PostgreSQL performance.

    Tue 8 2019 Ops and Administration
    Hans-Jürgen Schönig Finding and fixing slow queries

    presented by Hans-Jürgen Schönig

    Your database is performing badly but you got no idea why. Fortunately PostgreSQL has all the means to figure out what is really going on inside your database. You just have to find the right modules and use the right tools and understand what PostgreSQL is really trying to tell you. This talk will show you how to track down slow queries using pg_stat_statement, work with "explain analyze" and...

    more

    Wed 18 2019 Ops and Administration
    Hans-Jürgen Schönig 10 Steps to good PostgreSQL Performance

    presented by Hans-Jürgen Schönig

    Are you suffering from bad performance? Do you have the feeling that your database can do a lot better? Well, maybe it really can. This talk will provide you with a simple guideline to ensure superior database performance using a systematic approach to tuning and especially to performance analysis. You will learn to find missing indexes (which will help to cut performance problems in half), fin...

    more

    Thu 19 2019 Ops and Administration
    Hans-Jürgen Schönig The PostgreSQL optimizer: What it really does

    presented by Hans-Jürgen Schönig

    What does the query optimizer really do? Is it magic? Is it Voodoo? What is really going on there? And what does all this "cost thing" really mean? Well, let us dive into the optimizer and find out, what is really going on deep inside the planner. You will be guides through the basic optimization and learn how the optimizer calculates costs, prunes joins, handles parallel queries, flattens subs...

    more

    Thu 19 2019 Dev
    Hans-Jürgen Schönig Simple steps to superior database performance

    presented by Hans-Jürgen Schönig

    Are you suffering from bad performance? That might not be necessary. A simple and easy approach can help to sort out many performance problems fast and efficiently. By using a systematic approach many nasty issues can be solved and users can be kept happy. During this talk you will learn to systemmatically approach a system and make it fast again.

    Wed 20 2019 Data
    Hans-Jürgen Schönig Processing 1 billion rows per second

    presented by Hans-Jürgen Schönig


    video

    Everybody is talking about Big Data and about processing large amounts of data in real time or close to real time. However, to process a lot of data there is no need for commercial software or for some NoSQL stuff. PostgreSQL can do exactly what you need and process A LOT of data in real time. During our tests we have seen that crunching 1 billion rows of data in realtime is perfectly feasible,...

    more

    Thu 30 2017 Use Cases
    Hans-Jürgen Schönig Detecting performance problems and fixing them

    presented by Hans-Jürgen Schönig

    Are you facing bad performance? maybe you are not sure how to approach performance problems systematically? This training is what you have been looking for. During this training you will learn: - How to detect performance problems - Tracking down slow queries - Hunting I/O problems - Optimizing postgresql.conf for speed - Optimizing storage - Finding slow stores procedures - Playing with lockin...

    more

    Tue 28 2017 Training
    Hans-Jürgen Schönig Digging into advanced SQL
    Analyzing huge amount of data with super efficient modern SQL

    presented by Hans-Jürgen Schönig

    While SQL is a really powerful thing, most people don't harvest the full potential of the language. The idea of this training is to introduce people to some of the more advanced features of PostgreSQL such as windowing functions and analytics, ordered set, recursive SQL, and a lot more. This full day training will introduce you to all the advanced stuff you might have never heard of but which...

    more

    Development
    Hans-Jürgen Schönig ora_migrator: Moving from Oracle to PostgreSQL
    A new tool to move to PostgreSQL

    presented by Hans-Jürgen Schönig

    Moving from Oracle to PostgreSQL has become some sort of national sports. A couple of tools have already been developed to make the move to PostgreSQL easier. However, as none of the tool the tools really satisfied and therefore we came up with ora_migration, a tool, which allows to migrate data and other stuff to PostgreSQL fast and easily.

    Thu 19 2018 Use Cases