Hans-Jürgen Schönig @postgresql_007
CEO at CYBERTEC PostgreSQL International GmbH
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.
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 Developmentpresented 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 DevBecause 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 AdministrationBuilding 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 Administrationpresented 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...
morepresented 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 Administrationpresented 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 AdministrationSpeeding 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 Administrationpresented 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 Administrationpresented 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 Administrationpresented 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 Devpresented 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 Datapresented 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 Casespresented 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 TrainingAnalyzing 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 DevelopmentA 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