Jimmy Angelakos

We kick off with a short DEV/DBA/DBRE panel discussion to surface the most common “Postgres at scale” failures. Then the mic is open: attendees can step up for a lightning confession : A real production “obvious fix” that backfired, the metric that proved it, and what they’d do differently.

PostgreSQL now runs everywhere, on-prem, cloud-managed, on Kubernetes. Each deployment model comes with its own monitoring stack, its own blind spots, and its own trade-offs.

PostgreSQL diagnostic tooling today asks you to compromise. Either you install an invasive agent on the database server before the incident: Datadog, Prometheus exporters, telegraf, monitoring sidecars, vendor agents, take your pick.

The success of open source databases like PostgreSQL and MySQL/MariaDB has created an ecosystem of derivatives claiming "drop-in compatibility." But as the distance between upstream and these derivatives grows, user confusion and brand dilution can follow. To address this, we explore the challenge of compatibility with de facto standards from two distinct angles: a governance perspective on…

Lack of awareness around Mental Health issues has always been a problem in IT circles, leading to stress, burnout and difficulties in workplace and community relationships. This often results in employee turnover and strained dynamics within open source projects, and creates barriers for achieving a diverse contributor base.

Row-Level Security (RLS) in PostgreSQL is awesome, as it allows you to isolate each user or tenant's data, lock it down and default to "deny access"... but it sucks because it makes assumptions about your application that are not applicable in many cases.

For those moments when you're craving a high-quality GIS dataset but everything is too expensive, OpenStreetMap is a free, community driven Open Data solution. Do you really need access to extortionately priced APIs for what you want to do?

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.

Many systems have commonalities that lend themselves to similar best practices for administration and maintenance. Database systems in particular are complex and have many correctness, performance, and security considerations.

Based on the legendary "Don't Do This" PostgreSQL wiki page, this talk explores some of the common pitfalls and misconceptions that Postgres users can face - and shows possible ways to undo them or workarounds.

Based on the legendary "Don't Do This" PostgreSQL wiki page, this talk will explore some of the common pitfalls and misconceptions that Postgres users can face - and show possible ways to undo them or workarounds.

Based on the legendary "Don't Do This" PostgreSQL wiki page, this talk will explore some of the common pitfalls and misconceptions that Postgres users can face - and show possible ways to undo them or workarounds. Some of the topics to be covered: Correct types for data storage (Sub-)Partitioning And how to get it wrong Bad SQL habits Table inheritance And how to undo it Security issues Unsafe…

An open discussion with Postgres community members around the topic of upgradability. We will be looking at the PostgreSQL development cycle (backward compatibility, addition of new features) and why it makes sense to upgrade Postgres regularly.

It's easy to get misled into overconfidence based on the performance of powerful servers, given today's monster core counts and RAM sizes. However, the reality of high concurrency usage is often disappointing, with less throughput than one would expect.

How to navigate the rich but confusing field of (Full) Text Search in PostgreSQL. A short introduction will explain the concepts involved, followed by a discussion of functions, operators, indexes and collation support in Postgres in relevance to searching for text.

A look at some of the ways available to deploy Postgres in a Kubernetes cloud environment, either in small scale using simple configurations, or in larger scale using tools such as Helm charts and the Crunchy PostgreSQL Operator. A short introduction to Kubernetes will be given to explain the concepts involved, followed by examples from each deployment method and observations on the key…