PDXPUG March 2023: Know Your Index

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.

Advertisement

PDXPUG February 2023: Raven, a story of adopting Postgres

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.

PDXPUG January 2023: What’s new in PostgreSQL 15

2023 January 19 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: Mark Wong

PostgreSQL 15 was released on October 13, 2022 so let’s give it a look!

We will shamelessly use a presentation readily available on the internet to see all the newness in this latest release.

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

PDXPUG August 2022: “Elephants at the Watering Hole” – A World Elephant Day Celebration with SFPUG

Join us virtually on August 10, 2022 as we celebrate World Elephant Day with “Elephants at the Watering Hole” – a PostgreSQL open discussion!

Instead of a single speaker, we’ll open the virtual floor and give everyone a chance to speak.

This is a joint event with our friends at SFPUG!

Share your favorite tips and tricks, your “you won’t believe this!” stories, and your enthusiasm for all things Postgres.

Schedule:
12:00 PM Announcements, discussion.
1:15 PM Closing announcements, wrap up.
1:30 PM Event ends.

Link and password for the GoToMeeting room will be sent via MeetUp on the evening before the event.

PDXPUG April 2021: Tidying Up Your Data with The San Francisco Bay Area PostgreSQL Meetup Group

Join us virtually on April 13, 2021 at 12:00PM,

Muffy Barkocy presents, “Tidying Up Your Data”.

Note: You will need to sign up via SFPUG’s Meetup announcement in order to get the link to join the virtual event.

Tidy up your relational databases by moving old data to alternative storage solutions and keeping live data live. A thought experiment based on Instacart’s process for creation, fulfillment, and maintaining history of orders.

Muffy has worked as a software engineer for more than 30 years. She started with packaged software for database interfaces, but latched onto Web development from the outset, excited by how it spoke to her vision of computers as a way to connect people around the world and change their lives. She has worked at Instacart since 2015, where she enjoys building tools for everyone, mentoring other engineers, and helping non-engineers learn more about technical topics.

Schedule:
12:00 PM Announcements, speaker introduction, presentation, Q&A.
1:15 PM Closing announcements, wrap up.
1:30 PM Event ends.

Link and password for the GoToMeeting room will be sent the evening before the event.

PDXPUG August 2020: Building a Database as a Service Platform

August 27th 2020 6:30 to 8:30

RESCHEDULED!  After missing July, we have moved this talk to this month.

Speakers: Grant Holly and Bryant Vinisky

Beginning in 2016, New Relic sought to design Megabase, its own RDS for its data center infrastructure. With one of the main authors Bryant Vinisky, we are going to talk about the design of megabase and how it works at New Relic. There will be a dive into how we run highly available Postgres databases with containers, as well as automating the life cycle management of databases. And of course, there will be live demos. It just wouldn’t be an authentic Grant presentation if there wasn’t a demo that blows up.

Stay tuned for more meeting updates.  We will be cross posting on meetup for RSVPs.  The meeting URL will go out around the day of the presentation.  I look forward to seeing everyone.

About the speakers:

Bryant Vinisky has over 10 years of professional engineering experience with Linux and the open source ecosystem, with much of that time concentrated on supporting PostgreSQL in various roles. Currently Bryant is a Senior Software Engineer and tech lead on the Database team at New Relic where he’s spent the past four years focused on the reliability of the backend system that operates at significant scale. Over the past three years in particular, his time has been centered on the development and support of an internal platform for managing stateful containers that house PostgreSQL and MySQL databases.

I am Grant Holly, I’ve been running Postgres in production since 9.2. I work with Bryant on the database engineering team at New Relic. Lately I’ve been into golang, career mentoring, and learning Spanish. I co-organize the Portland PostgreSQL User Group with Mark Wong and Jason Owen.

Meeting link: https://meet.jit.si/pdxpugaugustmeetup

PDXPUG July 2020: Building a Database as a Service Platform

July 16th 2020 6:30 to 8:30

RESCHEDULED for August!

Speakers: Grant Holly and Bryant Vinisky

Beginning in 2016, New Relic sought to design Megabase, its own RDS for its data center infrastructure. With one of the main authors Bryant Vinisky, we are going to talk about the design of megabase and how it works at New Relic. There will be a dive into how we run highly available Postgres databases with containers, as well as automating the life cycle management of databases. And of course, there will be live demos. It just wouldn’t be an authentic Grant presentation if there wasn’t a demo that blows up.

Stay tuned for more meeting updates.  We will be cross posting on meetup for RSVPs.  The meeting URL will go out around the day of the presentation.  I look forward to seeing everyone.

About the speakers:

Bryant Vinisky has over 10 years of professional engineering experience with Linux and the open source ecosystem, with much of that time concentrated on supporting PostgreSQL in various roles. Currently Bryant is a Senior Software Engineer and tech lead on the Database team at New Relic where he’s spent the past four years focused on the reliability of the backend system that operates at significant scale. Over the past three years in particular, his time has been centered on the development and support of an internal platform for managing stateful containers that house PostgreSQL and MySQL databases.

I am Grant Holly, I’ve been running Postgres in production since 9.2. I work with Bryant on the database engineering team at New Relic. Lately I’ve been into golang, career mentoring, and learning Spanish. I co-organize the Portland PostgreSQL User Group with Mark Wong and Jason Owen.

Meeting Link: https://meet.jit.si/pdxpugJulyMeetup

PDXPUG June 2020 PostgreSQL 13 Beta Preview with Christophe Pettus—Joint Event with San Francisco PUG!

Join us online on June 18, 2020 as Christophe Pettus presents a preview of the PostgreSQL 13 beta.

This exciting new release has many new features, covering a wide range of functionality: Indexing, query functionality and performance, vacuuming, monitoring and status reporting, partitioning, and a host of others. We’ll talk about the highlights of what to expect in version 13.

Christophe Pettus is the CEO and lead consultant of PostgreSQL Experts, Inc., a decade-old independent PostgreSQL consultancy.

Schedule:
7:00 PM Announcements, speaker introduction, presentation, Q&A.
8:15 PM Closing announcements, wrap up.
8:30 PM Event ends.

Link for the GoToMeeting room will be sent the day of the event.

PostgreSQL 13 Beta Preview with Christophe Pettus—Joint Event with Portland PUG!

Thursday, Jun 18, 2020, 7:00 PM

Online event
,

29 PostgreSQL Users and Developers Attending

SFPUG is going virtual—and we’re doing a joint Meetup with our friends at the Portland PUG! Join us online on June 18, 2020 as Christophe Pettus presents a preview of the PostgreSQL 13 beta. This exciting new release has many new features, covering a wide range of functionality: Indexing, query functionality and performance, vacuuming, monitoring a…

Check out this Meetup →

PDXPUG April 2020: Multiranges and SQL:2011 Temporal Features

2020 April 23 Meeting 6:30pm-8:30pm

Note: This will be an online event. You must RSVP to get the link to the meeting, which will be set shortly before the meeting as we will be using Jitsi. Jitsi can be used directly with Firefox and Chrome (with extension), or phones/tablets with the Jitsi Meet app.

Speaker: Paul Jungwirth

I’d like to present a couple patches I have in-progress for Postgres, the first to add a new type called “multiranges”, and the second to add various SQL:2011 temporal database features: temporal primary & foreign keys, and temporal UPDATE and DELETE. I’ll discuss what these features look like to users and also highlight some of the implementation details behind them.

 

PDXPUG February 2020 Meetup: DBlink and SQL/MED and FDW, oh my! External Data Access tricks

2020 February 20 Meeting 6pm-8pm

Location:

PSU Business Accelerator
2828 SW Corbett Ave · Portland, OR
Parking is open after 5pm.

Speakers: Gabrielle Roth & Michelle Franz

In February, long-term PDXPUGers Michelle Franz & Gabrielle Roth return to discuss DBLINK and FDW, two methods of accessing data that’s outside your database. We’ll briefly mention SQL/MED on the way, and tell a couple of bad (Dad) jokes.

We’ll cover use (and mis-use) cases, configuration of each, and interesting quirks. Gabrielle will attempt a live demo of file_fdw and postgres_fdw. You’re welcome to follow along if you’d like, just show up with a couple of Pg databases: they can be on the same cluster (or container or RDS instance or what have you) or different ones, doesn’t really matter. One of them should have at least one table with data in it.

About the speakers:

From embedded systems to UI to relational database programming, Michelle’s running an interesting path through the software world. Working with databases is her current episode, with some programming, some DBA, some SysAdmin and a healthy dose of learning agile. She’s very quickly come to appreciate and enjoy working with Postgres and her work has allowed her to learn from some super talented database experts.

Gabrielle has been using Postgres since sometime in the version 7s, and thinks that the best part of using Open Source software is the culture of sharing knowledge. She’s a Senior Data Engineer at NS1 and co-founder and former co-lead of PDXPUG.