PostgresWorld Training 2026 Program
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 EssentialsYou 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 Essentialspresented 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 EssentialsProtect 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 Essentialspresented 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{ 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