PDXPUG April Meeting: What’s new in PostgreSQL 17
PDXPUG | Portland Postgres Users Group
by markwkm
2w ago
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
Visit website
PDXPUG Mar 21: Replication with Postgres
PDXPUG | Portland Postgres Users Group
by grantholly
3w ago
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
Visit website
PDXPUG Feb 15: Zero Downtime: Live Data and Server Migrations
PDXPUG | Portland Postgres Users Group
by grantholly
2M ago
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
Visit website
PDXPUG Nov 2: What’s new in PostgreSQL 16
PDXPUG | Portland Postgres Users Group
by markwkm
6M ago
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
Visit website
PDXPUG Aug 17th: Developing Your Own Database Extensions
PDXPUG | Portland Postgres Users Group
by grantholly
7M ago
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
Visit website
PDXPUG May 2023: Django and Postgres
PDXPUG | Portland Postgres Users Group
by grantholly
7M ago
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
Visit website
PDXPUG April 2023: Know Your Index part 2
PDXPUG | Portland Postgres Users Group
by grantholly
7M ago
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
Visit website
PDXPUG March 2023: Know Your Index
PDXPUG | Portland Postgres Users Group
by grantholly
7M ago
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
Visit website
PDXPUG February 2023: Raven, a story of adopting Postgres
PDXPUG | Portland Postgres Users Group
by grantholly
7M ago
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
Visit website
PDXPUG January 2023: What’s new in PostgreSQL 15
PDXPUG | Portland Postgres Users Group
by markwkm
7M ago
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 ..read more
Visit website

Follow PDXPUG | Portland Postgres Users Group on FeedSpot

Continue with Google
Continue with Apple
OR