PostgresWorld Training 2026 Program

2026-01-20
09:00
Greg Dostatni PostgreSQL A-Z

presented by Greg Dostatni

This rapid-fire training offers a structured, systematic walkthrough of all PostgreSQL GUC parameters, highlighting the most impactful “low-hanging-fruit” settings that can deliver immediate performance improvements. Rather than overwhelming attendees with exhaustive deep dives, the session focuses on surfacing what truly matters first—ensuring that no relevant parameter is overlooked while mai...

more

09:00 - 15:00 Google Meet or Riverside Essentials
2026-02-05
09:00
Dave Stokes Learning SQL With PostgreSQL
You can learn SQL easily

presented by Dave Stokes

Want to learn Structured Query Language (SQL)? In this half day training you will learn the basics of SQL by using PostgreSQL. We will cover the syntax of common statements (INSERT, UPDATE, DELETE, SELECT< CREATE) plus have you run commands so that you can see the results. You will learn by doing in a highly interactive environment by directly using PostgreSQL. This workshop assume no previous ...

more

09:00 - 12:00 Google Meet or Riverside Essentials
2026-02-18
09:00
Greg Dostatni The Power of PostgreSQL Replication: Logically Speaking

presented by Greg Dostatni

Move beyond traditional physical replication and tap into PostgreSQL’s highly flexible, table-level data synchronization capabilities through Logical Replication. This training breaks down the concepts behind logical replication, showing how PostgreSQL streams actual row-level changes—rather than file-system blocks—using WAL as the transport layer. The session provides a clear, practical unders...

more

09:00 - 10:30 Google Meet or Riverside Essentials
2026-02-24
10:00
Dave Stokes Keeping Bad Data Out Of Your Database
Protect Your Instances!

presented by Dave Stokes

It is easier to keep bad data from getting into your database than it is to find it, and fix it later. This tutorial shows you how to keep the bad stuff out by the proper use of data types, check constraints, exclusions and more. We will also discuss how you never, ever trust data from an user without filtering it for potentially harmful content. Malicious users will try to exploit any security...

more

10:00 - 11:30 Google Meet or Riverside Essentials
2026-03-10
09:00
Greg Dostatni PostgreSQL Performance and Maintenance

presented by Greg Dostatni

Designed for DBAs and DevOps engineers, this training delivers an overview of foundational knowledge for managing PostgreSQL performance and maintenance, delivered as two 3 hour workshops. It includes a guide to assist with evaluating and benchmarking storage options and how specific values relate to database workloads both in cloud and on prem. We conclude with a detailed discussion of many pe...

more

09:00 - 15:00 Google Meet or Riverside Ops
2026-03-26
10:00
Dave Stokes JSON_DATA() At Full Strength
{ JSON: true }

presented by Dave Stokes

Data in JSON format can become problematic. First, it breaks your data normalization. Send, most of the SQL functions you know and love do not work with JSON. But there are legitimate reasons to use JSON for storage. And there is a way to temporarily transform your JSON data for processing with SQL. JSON_TABLE() makes your JSON data available for use with all the PostgreSQL commands you are ...

more

10:00 - 11:30 Google Meet or Riverside Essentials