Hans-Jürgen Schönig

Kubernetes and OpenShift are some of the most widespread deployment methods to run PostgreSQL these days. In important environments many people rely on multiple data centers.

Many people talk about it - we use it in fact and help our customers. But what can AI actually be used for in real life and why is PostgreSQL such a great database for this?

After more than 25 years working with PostgreSQL, we’ve seen it all, from clever hacks to some of the most ambitious deployments out there. PostgreSQL’s rich ecosystem makes it possible to cover just about every need, including monitoring, tuning, automation, compliance, scalability, and high availability.

When getting started with PostgreSQL and databases in general everybody is concerned about performance. However, the question is: What are the most important steps to speeding up your database and what are the pitfalls one will face when trying to improve performance?

PostgreSQL is gaining popularity every day, but what does it really mean to run PostgreSQL in the real world? How does it impact an insurance company, a startup, a personal project, or research endeavors?

This is the second addition of performance tricks one has never seen before. Let us take a look at some of the hidden trickery a PostgreSQL consultant can use to make life better.

Performance ist ein wichtiges Thema, das bei den meisten Usern ganz oben auf der Agenda steht. Im Rahmen dieses Vortrags wollen wir uns einige der weniger bekannten aber hoch effektiven Performance Tips vorgestellt werden. Von Storage bis hin zu Query Tuning.

SQL offers a lot more than just simple features but allows you to execute more advanced queries including recursions, grouping sets and even custom aggregation functions. During this during you will learn about some of the more advanced features available to users of PostgreSQL and you will be guided through some practical use cases.

PostgreSQL has come a long way and people use it as an integral part of their infrastructure. We are working hard to make integration as easy as humanly possible and help customers to run PostgreSQL in a comprehensive environment.

Wer von Oracle auf PostgreSQL migriert, wird eine Reihe von Features vorfinden, die man auf Oracle vermisst hat, ohne es zu wissen. Grund genug sich einige dieser Dinge genauer anzusehen, um die User Experience auf der neuen Umgebung entscheidend zu verbessern.

PostgreSQL stores data on disk in its standard format. Once in a while it is necessary to make sure that the disk is encrypted and the database can only start if a key is provided.

Many people are still using Oracle and are therefore suffering. High costs, high maintenance, inflexibility and so on are just some of the things people complain about.

PostgreSQL is more and more used for critical applications. Therefore we see more and more demand for high-security PostgreSQL, high-availability and encryption.

The PostgreSQL optimizer is an important and sophisticated piece of software, which is often quoted but rarely understood. Let us put and end to this and explain, what really goes on behind the scenes.

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.