PDXPUG Septemter 8, 2026, MeetUp: Migrating to a Temporal Schema

Posted on by
Reply

Please note different time and location this month at UpStart Collective at the U.S. Bancorp Tower (a.k.a. Big Pink). Please RSVP on MeetUp. Tuesday September 8, 2026 from 6:30pm to 8:30pm.

Coinciding with devopsdays Portland, OR, Sept 8-10, 2026.

In v18, Postgres got temporal primary keys, unique constraints, and foreign keys (with `NO ACTION`). Hopefully in v19 we’ll have `UPDATE/DELETE FOR PORTION OF`. So it’s a good time to start thinking about migrating your schema to a temporal structure. Some advantages include:

– Easier queries and joins to reconstruct historical data.
– A better way to do soft-deletes (preserving referential integrity).
– No bugs from foreign key references to since-updated data.
– A less ad hoc way of representing historical data.

This talk will explore how to migrate your schema to include application-time `daterange` and `tstzrange` columns. I’ll use an existing schema for a time-tracking and invoicing application (used by me for over 12 years), showing the pain points of the old structure, not sparing my pride at some bad decisions, and give an approach to bring it all into a nicer temporal structure.

We will also talk about some remaining pain points in using temporal tables, and suggestions to mitigate them.
If you are contemplating a move to temporal tables, this talk will give you an overview of the landscape.

Presented by Paul Jungwirth:

Paul is a freelance software developer in Portland, Oregon.
He has built applications with Postgres since 2010 and is the author of several extensions.
His Postgres contributions include work on GiST indexes, multiranges, and SQL:2011 application-time features.

PDXPUG May 13 Tracking Database and Query Performance Data

Posted on by

2026 Wednesday May 13th Meeting 6:30pm to 8:30pm

Please note the new meeting location! We’re in downtown this month

Location: Portland State University Engineering Building (1930 SW 4th Ave Portland OR 97201)

https://maps.app.goo.gl/AzoJNF2snLKELRJa7

Speaker: Kellyn Pot’Vin-Gorman

Tracking database performance

We are going to look at a new performance tracking dashboard with Kellyn. She is going to take us though tracking database performance all the way down to the query level. This talk is for all levels, so don’t be shy, and bring your questions.

Kellyn joins us from Redgate where she works in engineering. She has been a prolific public speaker at events like PASS (Professsional Association of SQL Server) and SQL Saturday. Her back ground covers Oracle, SQL Server, Azure, and of course, our beloved Postgres as well. Kellyn is also involved with PDX Women In Tech as well, and has been a speaker on community, inclusion, and DEI.

When you get there, text or call the number on the sign to be let in.

PDXPUG April 17 Deep Dive into B-Trees

Posted on by

2026 Friday April 17th Meeting 6:30pm to 8:30pm

Please note the new meeting location! We’re in downtown this month

Location: Portland State University Engineering Building (1930 SW 4th Ave Portland OR 97201)

https://maps.app.goo.gl/AzoJNF2snLKELRJa7

Speaker: Mustafa Akur

Deep dive into B Trees

B-trees are the primary data structures for database indexing, and for good reason. In this session, we will examine why they are ubiquitous and remain the preferred choice for database workloads.

Mustafa Akur is a PhD student in Biomedical Engineering at Oregon Health & Science University (OHSU). His research focuses on developing AI models to improve the prognosis of prostate cancer. Prior to his doctoral studies, he worked on audio signal processing, acoustic recognition, and query engine plan optimization, specifically targeting streaming workloads.

When you get there, text or call the number on the sign to be let in.

PDXPUG March 19 Data Lake Architecture and Data Warehouse Trends

Posted on by

2026 Thursday March 19th Meeting 6:30pm to 8:30pm

Please note the new meeting location. And please RSVP on MeetUp as space is limited.

Location: Multnomah Arts Center – The front desk can guide you to the meeting room.

7688 SW CAPITOL HWY • PORTLAND, OR  97219

Speaker: Grant Holly

Data warehouses, data marts, data lakes, data swamps, data graveyards? I know. I’m confused too. Data lakes are increasingly common and pose many new challenges and opportunities. I’m going to overview some contemporary design patterns and hopefully shed some light on this popular architecture.

We’ll start with a fly-over of recent data warehousing history and core concepts. Then we will look at some popular catalogs and storage formats as well as covering OLAP engines for unlocking potential from data lakes.

Whether you are a grizzled veteran with PB of data, or you’re building your first reporting database, this talk is for you. We don’t take ourselves (too) seriously. Come and hang out, network, ask questions, share stories, and take it all in.

PDXPUG February 19th, 2026: What’s New in PostgreSQL 18

Posted on by

2026 Thursday February 19th Meeting 6:30pm:8:30pm

Please note the new meeting location. And please RSVP on MeetUp as space is limited.

Location: Multnomah Arts Center – The front desk can guide you to the meeting room.

7688 SW CAPITOL HWY • PORTLAND, OR  97219

Speaker: Mark Wong

PostgreSQL 18 was released September 25, 2025.

We will review freely available presentations available on the internet.

Come learn what’s new, share experiences, or just meet with local peers! Casual, informal.

https://www.meetup.com/pdxpug/events/312977438/

PDXPUG Sept 4th: OSS Database Spotlight Clickhouse

Posted on by

Thursday Sept. 4th 6:30pm

Location: American Red Cross

3131 N Vancouver Ave · Portland, OR

Speaker: Robert Hodges

Cheap, Fast, Scalable: Introducing Analytics with Open Source ClickHouse®

Real-time analytic databases are indispensable tools for quick insights on large datasets, and ClickHouse currently leads the pack in speed and usage. This talk shows the major features that make ClickHouse popular for real-time analytics and provides a jumping off point to build your own apps. We’ll explain internals of ClickHouse and provide explicit guidance on when to reach for it. (And when not to.;) We will also demo new work from Altinity that adds separable compute and storage using shared Apache Iceberg tables. We’ll include thoughts on design patterns for using PostgreSQL and ClickHouse productively together. 

We are so excited to host Robert and have him introduce another open source database Clickhouse. Robert has been working on databases since 1982, from pre-relational systems through modern analytic DBMS, with a focus on distributed systems and transaction processing He has worked principally with open source databases since 2006 and Kubernetes since 2018. His day job is running Altinity, a ClickHouse vendor.

Looking forward to seeing you all there.

FOSSY 2025 Conference at Portland State University

Posted on by

July 31st – Aug 3rd

Portland State University @ Smith Memorial Student Union building

This year Mark and I, with Richard Yen and Gabrielle Roth’s help, have been organizing the database track for the FOSSY conference. The conference focuses on open source software which makes the Postgres a perfect fit. We have put together a track of speakers in a range of topics spanning AI workloads, observability, community diversity, data ethics, and of course there are some Postgres-specific talks as well.

The conference has additional interesting tracks as well. You can check out all the details here: https://2025.fossy.us/ FOSSY 2025 starts July 31st through Aug 3rd. If you are keen on the database track, mark your calendar for Friday Aug 1st. There’s a keynote at 9:45 and the first database talks start at 10:45. Here’s a link to the full schedule

I am very pleased with the variety of talks we selected, and am looking forward to it. Hopefully I will see you there.

PDXPUG February 20th: OAuth Support in PostgreSQL

Posted on by

2025 Thursday February 20th Meeting 6:30pm:8:30pm

Location: American Red Cross

3131 N Vancouver Ave · Portland, OR

Speaker: Jacob Champion

We are going to have Jacob walk us through recent work on implementing OAuth support in Postgres.

Postgres has a wide array of supported authentication methods. The strongest methods have trouble scaling across large numbers of database instances, though, and while organizations have ways to centralize user credentials — for example by using LDAP or Kerberos — those solutions come with their own large lists of caveats. Jacob is currently developing Postgres-native support for OAuth, which is a widely-deployed framework for authorizing clients using a third-party provider. I’ll talk about the current state of the patchset, explain some of the elements of the design, and demonstrate what it might look like to deploy it yourself.

Now a bit about Jacob. Jacob Champion is a software developer at EDB and a contributor to PostgreSQL. He enjoys working on network security, protocol design, and authentication systems.

https://www.meetup.com/pdxpug/events/305777417/

PDXPUG October 24th: Pgbouncer for the Masses

Posted on by

2024 Thursday October 24th Meeting 6:30pm:8:30pm

Location: American Red Cross

3131 N Vancouver Ave · Portland, OR

Speaker: Grant Holly

Pgbouncer is a popular tool for Postgres users at any scale. Over the years, it has become the go-to database proxy for Postgres. You’ll likely find pgbouncer at the heart of all kinds of production workloads. Recently, there have been some pretty exciting releases adding new exciting features for things like prepared statements.

In this talk we are going to take a look at how to get started with pgbouncer. We will introduce the concept of a database proxy, then we will go into the details of connection pooling, configuration, high availability, and using pgbouncer to scale Postgres connections.

If you’ve never used pgbouncer before, this talk is for you! If you have used pgbouncer for years, this talk is also for you too!

Now a bit about me. I’m Grant. My name is part of the SQL language. I’ve been leading the Portland Postgres user group for a long time now along with Mark Wong. I’ve been working with Postgres in production since version 9.2, and conference speaker on Postgres.