2024 Thursday Feb 15th 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, is pretty close to her dream job of park ranger DBA. This presentation is going to cover Postgres sequences. Gabrielle will walk us through ..read more

Please RSVP on Meetup https://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 c ..read more

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 Pos ..read more

2024 Thursday Feb 15th Meeting 6:30pm:8:30pm Location (different than last time): TBD Speaker: Grant Holly Moving a live production dataset between servers is hard to do. I’m going to share a few examples of how I’ve been able to move data and workloads between servers without downtime, dropped writes, or stale reads. I had to break out more than a few Postgres tricks like logical replication, foreign data wrappers, and writable views, all of which we will be reviewing.  My goal is to share a few strategies that have worked and how they handle the common difficulties with moving live datasets ..read more

Please RSVP in MeetUp if you can: https://www.meetup.com/pdxpug/events/296865128/ 2023 Thursday November 2nd Meeting 6:30pm:8:30pm (Note non-typical week.) Location (different than last time): American Red Cross 3131 N Vancouver Ave, Portland, OR 97227 Speaker: Mark Wong 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. PostgreSQL 16 was released on September 14, 2023 so let’s give it a look! We will shamelessly use a presentation readily available on the inter ..read more

2023 August 17th Meeting 6:30pm:8:30pm Location: LAST MINUTE LOCATION CHANGE 830 NE Holladay Street Portland OR 97232 Speaker: Jerry Sievert Extensions are part of what makes Postgres such a powerful and popular database. Being able to add new capabilities to your database allows developers to adapt Postgres to many different use cases from geospatial (PostGIS), to multi-server sharding (Citus), to custom datatypes (pg_semver), to foreign data wrappers (postgres_fdw), and others. Jerry is going to walk us through getting started working on database extensions. We will cover how extensions work ..read more

2023 May 18th Meeting 6:30pm-8:30pm Location: PDX Code Guild 407 NE 12th Avenue, Portland, OR 97232 The parking lot is behind the building on Flanders. Speaker: Grant Holly Getting started with Django is a delight. However, as your application grows, that sqlite database you start with can become a limitation. We are going to look at how to wire up a new Django project to Postgres, and we will talk about some of the neat features in Postgres and Django that you can utilize including JSON, UDFs/procs, and extensions to name a few. Hopefully you can pick a few ideas, or even share your own ..read more

2023 April 20th Meeting 6:30pm-8:30pm Location: PDX Code Guild 407 NE 12th Avenue, Portland, OR 97232 The parking lot is behind the building on Flanders. Speaker: Grant Holly We are going to continue our tour of indexes in Postgres. This time around we are going to look into the index data structures, and how they affect performance. We will cover B+Trees, hash tables, and inverted indexes as well as looking at the Brin and SP-Gist indexes. Later we will talk about use cases for the different kinds of indices. And finally, we will settle the “indexes” vs “indices”! This talk is for all ex ..read more

2023 March 16th Meeting 6:30pm-8:30pm Location: PDX Code Guild 407 NE 12th Avenue, Portland, OR 97232 The parking lot is behind the building on Flanders.. Speaker: Grant Holly Postgres has many different kinds of indices for different use cases. Let’s take a look at the different options that come with indexing your data. We will also look at index trade-offs because, as you know, there’s no free lunch. This talk is for all experience levels. Bring your questions and stories. We are looking forward to seeing you there ..read more

2023 February 16th Meeting 6:30pm-8:30pm Location: PDX Code Guild 407 NE 12th Avenue, Portland, OR 97232 The parking lot is behind the building on Flanders.. Speaker: Leo Jacob Leon will walk us through his application called Raven and share his story about switching to Postgres from SQL Server. Meet Leo, and check out his data-driven application. We will look at some queries, and learn why he chose Postgres, and what made the switch to Postgres work. If you want to join us remotely, here is a link to the meeting ..read more