Postgres Digital Training Series Program

Unscheduled events
Hans-Jürgen Schönig Nov 14th, 9:00AM EST: 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

Grant Zhou  Muhammad Usama Dec 12th, 9:00AM EST: PgPool-II Performance and best practices

presented by Grant Zhou and Muhammad Usama

Pgpool II performance and best practises Online training Middleware can have a significant impact on the operation and performance of the database system. Pgpool-II is the middleware product that sits between the PostgreSQL server and database clients and is developed and maintained by a committed open source Postgres community that includes HighGo employees. The most widely used features i...

more

GRANT ZHOU Asif Rehman Dec 10th, 9:00AM EST: PostgreSQL Replication best practices and deployment

presented by GRANT ZHOU and Asif Rehman

Replication is a critical part of any database system that aims to provide high availability (HA) and effective disaster recovery (DR) strategy. In a nutshell, the database replication describes the process of coping data from the database instance to one or more database instances. Again, these instances can be in the same location or perhaps connected over a wide network.

The term Repli...

more

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