Webinars

The Magic of Window Functions in Postgres

Window functions are often used to simplify complex queries and for data analytics. They allow analysis that is normally performed in client applications to be more efficiently processed by the database server.

This presentation explains the many window function facilities and how they can be used to produce useful SQL query results.

In this webinar you will learn:

Why you should use native packages to install PostgreSQL on Linux

When it comes to installing PostgreSQL on a Linux distribution, using a native package is considered to be a better choice compared to installing from the source. In this webinar, we will discuss some benefits of using native packages to install PostgreSQL.

Optimizing Performance: Installers are shipped with “the lowest common denominator” and native packages use the OS libraries resulting in performance and maintenance benefits.

How to use postgresql.conf to configure and tune the PostgreSQL server

Tuning your PostgreSQL server plays an important role in making sure you get the most out of your server resources, and running with default parameters is not always enough. Using the PostgreSQL server configuration file postgresql.conf, we can tune the right area and make the most out of the server resources. The postgresql.conf file tuning parameters are classified into different categories including database connections, memory, optimizers, and logging.

In this webinar, you will learn:

Automating Postgres Deployments on AWS and VMware, with Terraform and Ansible

Deploying Postgres on AWS and VMware shouldn’t be a clunky, manual task. In 2020 and beyond, automation and Postgres will go hand in hand.
Highly available, fault-tolerant PostgreSQL database cluster creation and monitoring can now be deployed in a matter of minutes using Terraform and Ansible scripts. In this webinar, you will learn how developers, devOps, and DBAs can automate cloud and on-premise Postgres deployment with the help of Terraform and Ansible.

We will cover:

Conquering Data Migration from Oracle to Postgres

Once you have converted Oracle object definitions and stored procedures, moving the data is the next key stage.
There are three approaches for migrating data: Big-bang, Trickle, and Synchronize. While most migrations can be done using any one of these approaches, some migrations will require a combination of them.

In this webinar, we will cover the below approaches to migrating data from Oracle to Postgres:

- Big bang - One-time data load

- Trickle - One-time data load in parallel

Professionelle Postgres-Überwachung!

Überwachung ist ein entscheidendes Element des Datenbankökosystems und wichtig für die Gesamtleistung der Datenbank. Sie trägt zudem zum guten Zustand Ihrer Datenbank sowie zur langfristigen Stabilität Ihrer Datenbank und Anwendung bei.
Überwachung gestaltet sich jedoch schwierig, wenn man nicht weiß, welche Variablen man überwachen soll und wie das geht.

Folgendes lernen Sie in diesem Webinar: