Stephen Frost

This talk will cover various advanced SQL topics at a depth appropriate for the individuals in the room- we'll dive in where it's clear there is need, and skim parts that are well known.

PostgreSQL supports a number of different authentication mechanisms and while many of them are quite simple and easy to use, the enterprise-level authentication systems, which also support encryption of the connection, require setup beyond PostgreSQL and a deeper understanding of how authentication works. This talk will cover implementing the two most prevelant enterprise authentication...

An open discussion with Postgres community members around the topic of scaling up for challenging workloads. We will be looking at how PostgreSQL deals with each of these challenges, and discussing possible mitigations, tuning tips or workarounds.

While efficiently copying files is an important part of backing up your PostgreSQL database, there's far, far more that an enterprise backup tool needs to do. This talk will review the broad set of features in pgBackRest which makes it the most advanced enterprise backup solution for PostgreSQL and what the pgBackRest team focuses on while moving pgBackRest forward.

The PostgreSQL project has been involved with GSoC for many years and 2022 is our largest year with 12 contributors! This talk will be an overview of all of the GSoC projects, from the work on porting pgBackrest to Windows to the Performance Farm and the efforts to improve the regression tests in PostgreSQL to cover more code.

An often requested capability is transparent data encryption, where the bulk of the data is encrypted on the filesystem by the database engine. While this addresses only a limited number of attack vectors, it’s often called for by certain standard organizations.

Test your Postgres knowledge during our round of trivia with Stephen Frost from Crunchy Data. This session is meant to engage the audience with Postgres fun facts and wisdom and give out prizes to the winners.

Learn how to read EXPLAIN, EXPLAIN ANALYZE and about how you can influence query plans. One of the most complex parts of the PostgreSQL system is the planner and the optimizer.

We'll be looking at PostgreSQL configuration options (postgresql.conf) for logging and basic tuning parameters, how to monitor which queries are taking the most time using pg_stat_statements, going over EXPLAIN and EXPLAIN ANALYZE output for select queries (and the auto_explain module), what the EXPLAIN output means in terms of how the query is being executed, and then going over ways to improve t

In this talk we'll review Row-Level Security (RLS), how it works in PostgreSQL, provide examples and use-cases, and discuss how to leverage RLS in applications. We'll also cover what a leakproof function is and how it is related to RLS, and how to avoid performance pitfalls when working with RLS.

PostgreSQL supports a number of different authentication mechanisms and while many of them are quite simple and easy to use, the enterprise-level authentication systems require setup beyond PostgreSQL and a deeper understanding of how authentication works.