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.

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 thefull schedule

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

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/

2025 Thursday January 16th Meeting 6:30pm:8:30pm

Location:American Red Cross

3131 N Vancouver Ave · Portland, OR

Speaker: Mark Wong

Come have a look at the new features, improvements, and fixes in the the version 17 release.https://www.meetup.com/pdxpug/events/305148196/

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.

2024 Thursday August 22nd Meeting 6:30pm:8:30pm

Location:American Red Cross

3131 N Vancouver Ave · Portland, OR

Speaker: Paul Jungwirth

Benchmarking is an important part of developing database systems like Postgres. For businesses, benchmarking can guide important decisions around selecting a database management system, or evaluate configuration changes. However, while there are many standard benchmarks out there, setting up, configuring, running, and collecting results was left as an exercise to the reader.

Benchbase is an open-source benchmarking framework from Carnegie Melon University’s Database Group (https://github.com/cmu-db/benchbase). It helps you configure, run, and collect results from various standard benchmarks. It also provides a framework for authoring your own performance benchmarks, and wiring it up to the batteries-included configuration, running, and results collection provided by it.

Paul is going to walk us through Benchbase, and some recent work he has embarked on around creating a benchmark. If you are a veteran of benchmarking, or have never done a benchmark before, this talk is for everyone.

Now a bit about Paul. He’s a freelance software developer here in Portland, and has been building applications with Postgres since 2011. You can check out his work here (https://github.com/pjungwir/benchbase). Paul has been working on the Postgres project itself. He’s authored many database extensions, and his contributions to Postgres include work on GiST indexes, multiranges, and SQL:2011 application-time features.

2024 Thursday June 20th Meeting 6:30pm:8:30pm

Location:American Red Cross

3131 N Vancouver Ave · Portland, OR

Speaker: Paul Jungwirth

I am so excited to announce that this month we have Paul presenting ontemporal data. In this presentation, we’re going to get an introduction to temporal data, talk a bit about the SQL:2011 standards around it, and finally Paul’s work on integrating it with Postgres. He’ll also, time permitting, discuss some ideas for taking temporal data beyond the standard with features like temporal outer joins and aggregations.

Now a bit about Paul. He’s a freelance software developer here in Portland, and has been building applications with Postgres since 2011. Paul has been working on the Postgres project itself. He’s authored many database extensions, and his contributions to Postgres include work on GiST indexes, multiranges, and SQL:2011 application-time features.

I’m looking forward to seeing you all at the meeting and for a fascinating presentation.

2024 Thursday May 16th Meeting 6:30pm:8:30pm

Location:American Red Cross

3131 N Vancouver Ave · Portland, OR

Speaker: Gabrielle Roth

We are so excited to have Gabrielle presenting this month. Gabrielle is one of the founding members of the Portland Postgres Users Group, and has been an active member of the Postgres community for over 15 years. Currently she’s working at a small consulting company offering data solutions to scientists, which, in her words, isprettyclose to her dream job of park ranger DBA.

This presentation is going to cover Postgres sequences. Gabrielle will walk us through how to set yourself up for success and avoid exhaustion. If you already found yourself in trouble, she is going to walk us through int to bigint conversions. We’ll also look at few different strategies to fixing exhausted or nearly exhausted sequences.

Come join us!

Please RSVP on Meetuphttps://www.meetup.com/pdxpug/events/300096141/ so we have an idea how many folks are attending!

Date: Thursday April 18th, 2024
Time: 6:30pm to 8:30pm US Pacific

Location:
American Red Cross
3131 N Vancouver Ave, Portland, OR 97227

Speaker:Mark Wong

PostgreSQL 17 will be in feature freeze at the time of our April meeting, so let’s give it a look! Expected release date is September 2024.

As we’ve done for previous version previews, we’ll review presentations freely available on the Internet to see what we can can expect in this upcoming major release.

Come learn what’s coming up, share experiences with the changes if you’ve beta tested, or just meet with local peers! This is a casual, informal group.

Parking is available in front of the building. Please be prepared to show ID and sign in with security when entering the building. We will be in the Columbia Room on the second floor.

2024 Thursday Feb 15th Meeting 6:30pm:8:30pm

Location:American Red Cross

3131 N Vancouver Ave · Portland, OR

Speaker: Grant Holly

This presentation will cover replicating your data with Postgres with a focus on streaming and logical replication. We are going to look at how the different kinds of replication work. It will be whirlwind trip through the use-cases, advantages, and challenges with different kinds of replication.

If you are a Postgres veteran and can configure replication from memory: this talk is for you. If you are someone new to Postgres, or someone who is just curious about Postgres: this talk is for you too! I’m always open to questions.

Hi, it’s me again. I’m Grant. I’ve been working with Postgres in production since version 9.2. I’ve been a speaker and subject matter expert on Postgres. Along with Mark Wong, I co-lead the Portland Postgres User Group.