Viewing 0 current events matching “postgres” by Date.

Sort By: Date Event Name, Location , Default
No events were found.

Viewing 94 past events matching “postgres” by Date.

Sort By: Date Event Name, Location , Default
Thursday
Sep 18, 2008
PDXPUG
Free Geek

PostgreSQL Users' Group monthly meeting. Followed by refreshments at the Lucky Lab.

Topic: Visual Planner Presenter: Tom Raney, PSU Where: FreeGeek, 1731 SE 10th Avenue, Portland, OR When: 7pm, September 18, 2008

Tom Raney will be presenting the Visual Planner, a GUI tool written in Java that enables the user to peek inside the PostgreSQL planner's decision making process. The tool shows all plans that were evaluated including the plan that was picked for execution. Tom worked on this during Google Summer of Code, and credits Dr. Len Shapiro, a professor at Portland State University and PDXPUG regular, as a great help.

Tom showed off his tool during OSCON and has gotten some feedback from community members on it. He's working up a test example that should appeal to DBAs, and I'll link directly to the source code once he's got it ready.

This work also involves a patch to PostgreSQL, which should be available soon!

After the meeting, retire to the Lucky Lab for refreshments!

Website
Friday
Oct 10, 2008
PostgreSQL Conference West
through Portland State University Native American Student & Community Center

Join us for the second annual PostgreSQL Conference West! Scheduled to begin October 10 and go through the weekend, West being held at Portland State University is going to be the destination for learning, fun and general education about PostgreSQL.

Website
Thursday
Feb 12, 2009
PostgreSQL Portland Performance Practice Project (P5)
Portland State University Fourth Avenue Building (FAB)

2nd THURSDAY OF EACH MONTH, BEGINNING JANUARY 8, 7:00 PM PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE, FOURTH AVENUE BUILDING – ROOM 86-01

See website for more details.

Website
Thursday
Feb 19, 2009
PDXPUG: PostgreSQL Data Visualization
Free Geek

Monthly meeting of the Portland PostgreSQL Users' Group.

Ed Borasky will be speaking about Data Visualization.

Beers after at the Lucky Lab on Hawthorne.

Website
Thursday
Mar 12, 2009
PostgreSQL Portland Performance Practice Project (P5)
Portland State University Fourth Avenue Building (FAB)

Sponsored by the Computer Science Department, Portland State University

This series will consist of 5 to 6 presentations aimed at PostgreSQL database users who wish to learn more about tuning their systems for performance. Attendees will learn how to generate and interpret operating system (Linux) and database statistics, and the effects of some system tuning techniques. This involves studying the well known Online Transaction Processing (OLTP) benchmark called TPC-C ( www.tpc.org ). TPC-C was developed by a committee, representing all major players in the database marketplace, to be representative of typical online enterprise databases. TPC-C consists of a precisely defined schema and 19 queries. We will review the schema and queries and demonstrate how each tuning technique affects their performance. We will use an open source package that the speaker has developed, called DBT-2, which many DBAs have found useful.

PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE, FOURTH AVENUE BUILDING – ROOM 86-01

Website
Thursday
Mar 19, 2009
PDXPUG: eXtreme Database Makeover 2: PORTAL
Free Geek

Monthly meeting of the Portland PostgreSQL Users' Group.

Kristin Tufte will be speaking about the Portland Transportation Archive Listing (PORTAL) database schema.

Beers after at the Lucky Lab on Hawthorne.

Website
Thursday
Apr 9, 2009
PostgreSQL Portland Performance Practice Project (P5) - Linux Filesystems
Portland State University Fourth Avenue Building (FAB)

PostgreSQL Portland Performance Practice Project (P5)

Sponsored by the Computer Science Department, Portland State University

This series will consist of 5 to 6 presentations aimed at PostgreSQL database users who wish to learn more about tuning their systems for performance. Attendees will learn how to generate and interpret operating system (Linux) and database statistics, and the effects of some system tuning techniques. This involves studying the well known Online Transaction Processing (OLTP) benchmark called TPC-C ( www.tpc.org ). TPC-C was developed by a committee, representing all major players in the database marketplace, to be representative of typical online enterprise databases. TPC-C consists of a precisely defined schema and 19 queries. We will review the schema and queries and demonstrate how each tuning technique affects their performance. We will use an open source package that the speaker has developed, called DBT-2, which many DBAs have found useful.

Mark Wong has an MS in Computer Science from OGI and several years of experience developing and executing various database systems benchmarks. Most relevant to this series are his years spent at the OSDL developing and using a fair-use derivative of the TPC-C benchmark to characterize system performance of open source software.

2nd THURSDAY OF EACH MONTH, BEGINNING JANUARY 8, 7:00 PM PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE, FOURTH AVENUE BUILDING – ROOM 86-01

Website
Thursday
Apr 16, 2009
PDXPUG - MySQL war stories: Tales from the Crater
Free Geek

Monthly meeting of the Portland PostgreSQL Users' Group.

Chris May will be speaking.

Looking forward to seeing everyone there...and of course, drinks at the Lucky Lab (http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterwards.

Website
Thursday
May 14, 2009
PostgreSQL Portland Performance Practice Project (P5)
Portland State University Fourth Avenue Building (FAB)

This session will survey a few PostgreSQL tuning parameters and their effects on the OLTP workload DBT-2.

--

PostgreSQL Portland Performance Practice Project (P5)

Sponsored by the Computer Science Department, Portland State University

This series will consist of 5 to 6 presentations aimed at PostgreSQL database users who wish to learn more about tuning their systems for performance. Attendees will learn how to generate and interpret operating system (Linux) and database statistics, and the effects of some system tuning techniques. This involves studying the well known Online Transaction Processing (OLTP) benchmark called TPC-C ( www.tpc.org ). TPC-C was developed by a committee, representing all major players in the database marketplace, to be representative of typical online enterprise databases. TPC-C consists of a precisely defined schema and 19 queries. We will review the schema and queries and demonstrate how each tuning technique affects their performance. We will use an open source package that the speaker has developed, called DBT-2, which many DBAs have found useful.

Mark Wong has an MS in Computer Science from OGI and several years of experience developing and executing various database systems benchmarks. Most relevant to this series are his years spent at the OSDL developing and using a fair-use derivative of the TPC-C benchmark to characterize system performance of open source software.

2nd THURSDAY OF EACH MONTH, BEGINNING JANUARY 8, 7:00 PM PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE, FOURTH AVENUE BUILDING – ROOM 86-01

Website
Thursday
May 21, 2009
PDXPUG: Introductory Database Education at PSU
Free Geek

by Len Shapiro

Abstract: I'll survey how I teach the introductory database course at PSU. My goal for the talk is to elicit suggestions for how I could do a better job. The theme of the course is "transforming data into Information". I use a 200 Meg database, hosted on PostgreSQL, instead of the one-slide databases used in typical intro courses, to illustrate the principles of the course. The database is Federal Elections Commission data re donations to candidates, so queries often reflect real questions about the real data.

Bio: Len Shapiro has been a professor at PSU for 23 years. His research interests are primarily in query processing.

Website
Thursday
Jul 16, 2009
PDXPUG - PostGIS and the Census Data
Free Geek

Webb Sprague will be speaking about PostGIS and the Census Data at the next PDXPUG meeting at FreeGeek (at 7:00pm - 1731 SE 10th Avenue, Portland, OR).

Looking forward to seeing everyone there....and of course, drinks at the Lucky Lab http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterwards.

More details from Webb:

If anyone is wondering about specifics, I will describe how I recently created a "crosswalk" table that correlates census tracts in 1980 with census tracts in 2000 in the Portland region (well, Washington, Multnomah, and Clackamas counties), so that we could see poverty trends over the last 25 years.

I used PostGIS, Census naming conventions ("FIPS codes"), and lots of outer joins. So if you like that sort of thing, I would love to hear your comments tomorrow!

Website
Thursday
Aug 20, 2009
PDXPUG
Free Geek

Join the Portland PostgreSQL Users' Group for our monthly meeting!

Where: FreeGeek When: 7pm 20 August, 2009 Who: Jim Cser What: Metro simulation database

Drinks afterward at the SE Lucky Lab.

Website
Thursday
Sep 17, 2009
PDXPUG
Free Geek

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 17 Sept, 2009 Who: David Wheeler What: Unit Test Your Database!

Drinks afterward at the SE Lucky Lab.

Website
Thursday
Oct 15, 2009
PDXPUG: Bucardo replication with tiny little goats
Free Geek

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 15 Oct, 2009 Who: Selena Deckelmann What: Bucardo: Replication with tiny little goats

Drinks afterward at the SE Lucky Lab.

Website
Thursday
Nov 19, 2009
PDXPUG: November meeting: Materialized Views
Free Geek

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 19 Nov, 2009 Who: Dan Colish What: Materialized Views (with cupcakes)

Drinks afterward at the SE Lucky Lab.

Website
Thursday
Mar 18, 2010
PDXPUG
Free Geek

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 18 Mar, 2010 Who: you! What: PostgreSQL 9.0alpha testing party

Drinks afterward at the SE Lucky Lab.

Website
Thursday
May 20, 2010
PDXPUG
Free Geek

Join the Portland PostgreSQL Users' Group for our monthly meeting!

When: 7pm Thursday, May 20 Where: FreeGeek Who: Melissa Hollingsworth What: Normalization!

Drinks afterward at the SE Lucky Lab.

Website
Thursday
Jun 17, 2010
PDXPUG (Portland PostgreSQL Users' Group)
Free Geek

Join the Portland PostgreSQL Users' Group for our monthly meeting!

When: 7pm Thursday, May 20 Where: FreeGeek Who: Mark & gabrielle What: What's new in 9.0

Drinks afterward at the SE Lucky Lab.

Website
Thursday
Sep 16, 2010
All about PostGIS (at Portland PostgreSQL Users Group)
Free Geek

Location-based services are all the rage these days, and almost everyone has a latitude and longitude or two stashed away in a numeric column somewhere. But, there is so much more to it than just a point. Once relegated to government and academia, geographic information systems are becoming increasingly visible. With the PostGIS extension, PostgreSQL is a first-class geodatabase and an incredible platform for working with spatial data, but what is PostGIS and why would one use it? And beyond PostGIS there are a dizzying array of tools to load, visualize and interact with the wonderful geospatial information in your database. This talk will cover GIS and PostGIS basics and provide an introduction to geodatabases and spatial queries.

--

Edwin Knuth spent quite some time as a sysadmin and web developer before going back to school to study Environmental Science at the University of Alaska Southeast. He quickly became fascinated with Geographic Information Systems and realized that GIS was just a really neat database application. In Alaska, Edwin worked on several unique projects, including building bat detectors and using PostGIS to manage a wireless sensor network on the Juneau Icefield. He has lived in Portland for the past year and loves it very much.

Then a trip to the Lucky Lab after.

Website
Thursday
Oct 21, 2010
PDXPUG: Postgres + node.js
Free Geek

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 21 Oct, 2010 Who: Aurynn Shaw What: PostgreSQL and node.js

Postgres and Node.js, a powerful event-driven programming environment paired with our favourite open-source database, now together in the same great package! Aurynn will be going over the node.js environment, how it differs from other programming environments, and how to use postgres with node.

Aurynn Shaw is Lead Userspace Developer at Command Prompt, Inc. She has come all the way from another country to present this talk, so don't miss it!

Beer afterwards at the Lucky Lab.

See you there!

Website
Thursday
Apr 21, 2011
PDXPUG: Distributing Extensions on PGXN
Free Geek

This month's meeting marks the fourth installment in our "Founders Series"..

When: 7-9pm Thu Apr 21, 2011 Where: FreeGeek Who: David Wheeler What: Distributing Extensions on PGXN

So you've solved a common problem in PostgreSQL, a serious pain point that lots of other people could take advantage of. You want to open-source the code, and would like to package it up and distribute it where people can find it, read its docs, and download and install it.

The newest destination for distributing PostgreSQL extensions is PGXN, the PostgreSQL Extension network. PGXN offers a central index of PostgreSQL extensions and their documentation, making it easy for people to find an install extensions.

How do you optimize your extension distribution for maximum PGXN exposure? By careful packaging, thorough documentation, and simple installation. Join me for an overview of how best to achieve that — including how to build extensions compatible with PostgreSQL 9.1's improved extension support.

David Wheeler is an associate at PGExperts, and is responsible for PGXN, the PostgreSQL Extension Network) and pgTAP. He's into testing and extension distribution.

Beer afterwards at the Lucky Lab. See you there!

Website
Thursday
May 19, 2011
PDXPUG
Free Geek

Normally, Gabrielle ensures that we have thoughtful and informative presentations. Unfortunately for you, I -- Melissa -- am guest-hosting this month.

What I'll come up with is anyone's guess, but BYOB is strongly recommended. Muahahaha.

Oh, and we may also talk about Postgres or something. And we'll join those folks at the Lucky Lab afterwards.

Thursday
Jul 21, 2011
PDXPUG
Free Geek

This month's topic is "Data Visualization and Exploration Techniques Using R and Postgres" with PSU's Dr Christopher Monsere.

Full details: http://pugs.postgresql.org/node/1669

Website
Sunday
Jul 24, 2011
PgDay at OSCON
Oregon Convention Center

Coming to OSCON? Be sure to come a day early and join us for another PgDay! This summer marks PDXPUG's 5th anniversary, and we want to see your smiling face! We will be celebrating at Gotham Tavern after the day of sessions. Sign up for sessions and afterparty here: http://bit.ly/f1F2Mz .

Yes, it's ok to show up just for the afternoon (or the party) if your flight arrives on Sunday.

We'd like a $30 donation to SPI for the sessions, but don't let lack of funds deter you from attending.

Website
Thursday
Aug 18, 2011
PDXPUG: Lessons from managing way too many databases at Facebook
Free Geek

Rob Wultsch, a recent addition to Facebook's Database Operations team, will compare and contrast the Facebook deployment with his previous work with another large deployment of open source databases. In this db-agnostic talk, he'll go over: the bizarre becoming ordinary, the many types of infrastructure that do not scale and what does and does not work when building a DBA team.

Before joining Facebook, Rob worked for a very large hosting company as a database administrator and a newspaper as a web developer. In his free time he enjoys riding his motorcycle and bicycle and fantasizes about moving to Portland.

As always, beer afterwards at the Lucky Lab. See you there!

Website
Thursday
Sep 15, 2011
PDXPUG: Practical PostgreSQL Performance
Free Geek

When: 7-9pm Thu Sep 15, 2011 Where: FreeGeek Who: Joshua Drake What: Practical PostgreSQL Performance

This presentation provides down tot earth performance advice.

Joshua D. Drake (JD) is lead consultant at Command Prompt, Inc. and President of PgUS.

Beer afterwards at the Lucky Lab. See you there!

Website
Thursday
Oct 20, 2011
PDXPUG: Upgrading PostGIS
Iovation

When: 7-9pm Thu Oct 20, 2011 Where: Iovation Who: Brent Dombrowski What: Upgrading PostGIS from 8.something to 9.0

See PDXPUG blog (linked) for details.

Website
Thursday
Nov 17, 2011
PDXPUG: collectd and Postgres
Free Geek

See PDXPUG blog (linked) for details.

Website
Thursday
Jan 19, 2012
PDXPUG: Database Tracking
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Feb 16, 2012
PDXPUG: Locks, etc
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Mar 15, 2012
PDXPUG: NoSQL for People Living Under a Rock
Iovation

See PDXPUG blog (linked) for details. Also, "beware the Ides of March", &c.

Website
Monday
Apr 2, 2012
Cloud Foundry Open Tour 2012 - Portland
The Nines Hotel

Get 10% off this developer event with code, "epdx_10"! (That's on top of the 50% early bird special - ends March 18!) The Cloud Foundry Open Tour gives enterprise developers expert instruction on how to get the best results from Platform-as-a-Service in the cloud. Register for this event to learn: * Basic Cloud Foundry commands for both the public and micro clouds *Cloud application development tips for Spring, Java, Ruby and Node.js * How to connect to application services like MySQL, MongoDB, Redis and RabbitMQ

Meet the experts behind the leading open source cloud platform for enterprise applications, discuss the latest innovations with other developers and expand your opportunities by attending the Cloud Foundry Open Tour.

Website
Thursday
Apr 19, 2012
PDXPUG: Data Near Here
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
May 17, 2012
PDXPUG: Replication Without Tears
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Jun 21, 2012
PDXPUG: Databases from Android
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Aug 16, 2012
PDXPUG: Vertically Scaling Postgres
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Sep 20, 2012
PDXPUG: Sqitch
Iovation

See PDXPUG blog (linked) for details.

Sqitch information is at http://sqitch.org/

Website
Thursday
Nov 15, 2012
PDXPUG: Sqitch
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Jan 17, 2013
PDXPUG: PostgreSQL in the Cloud
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Feb 21, 2013
PDXPUG: Dawn of a New Backup Era
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Mar 21, 2013
PDXPUG: Autovacuum and You
Iovation

Autovacuum’s like a Roomba, right? You just turn it on and it does all the work for you. Well, not quite – for one, your pets can’t ride around on it – and occasionally it may get stuck in a (figurative) corner. In this talk, we’ll discuss vacuum, analyze, and their daemonic counterparts: how to adjust them to perform appropriately*, and perhaps more importantly, what the heck are they actually doing?

This is a beginner-to-intermediate level talk, but you will learn something new about vacuuming, regardless.** –

Gabrielle Roth is a consultant with EnterpriseDB. She specializes in network, database, and system monitoring, as well as abusing SQL.

After-meeting beer location: Huber’s, the oldest bar in Portland. See you there!

Website
Thursday
Apr 18, 2013
PDXPUG: Extreme Database Makeover
Iovation

See link for details.

Website
Wednesday
May 15, 2013
PDX PHP
McMenamins Market St. Pub

Join us for the kickoff of the Portland PHP Meetup! The first meeting will be very informal. We will meet and discuss what topics we'd like to schedule for future meetup.

Bring a friend!

Website
Thursday
May 16, 2013
PDXPUG: Lightning Talks
Iovation

See link for details.

Website
Thursday
Jun 20, 2013
PDXPUG: Lightning Talks
Iovation

See link for details.

Website
Wednesday
Jul 24, 2013
PDXPUG: July meeting
Emma

We have some special out-of-town guests here for OSCON, so we're having a special meeting for July. Details will be posted on the pdxpug website: http://wp.me/p25MlK-4r

Note that this is not our regular meeting time, day, or location!

Website
Thursday
Aug 15, 2013
PDXPUG: YAMS Aren't Sweet Potatoes
Iovation

See link for details.

Website
Thursday
Sep 19, 2013
PDXPUG: JSON
Iovation

See link for details.

Website
Thursday
Oct 17, 2013
PDXPUG: UrbanFootprint
Iovation

Portland Postgres Users Group. See link for details.

Website
Thursday
Nov 21, 2013
PDXPUG: Aquameta
Iovation

Portland Postgres Users Group. See link for details.

Website
Thursday
Jan 16, 2014
PDXPUG: January meeting
Iovation

Portland Postgres Users Group. See link for details.

Website
Saturday
Jan 25, 2014
PDXPUG: Streaming Rep Saturday workshop
Emma

See web link for details.

Advanced signup is required.

Website
Thursday
Feb 20, 2014
PDXPUG: February meeting
Iovation

Portland Postgres Users Group. See link for details.

Website
Thursday
Mar 20, 2014
PDXPUG: March meeting
Iovation

Portland Postgres Users Group. See link for details.

Website
Thursday
Apr 17, 2014
PDXPUG: April meeting
Iovation

Portland Postgres Users Group. See link for details.

Website
Thursday
May 15, 2014
PDXPUG: May meeting
Iovation

Portland Postgres Users Group. See link for details.

Website
Thursday
Jun 19, 2014
PDXPUG: June meeting
Iovation

Portland Postgres Users Group. See link for details.

Website
Tuesday
Jul 22, 2014
PDXPUG: July meeting: OSCON BoF

Portland Postgres Users Group. See link for details.

Note that this is not our regular meeting time or place!

Website
Thursday
Aug 21, 2014
PDXPUG: August meeting

Portland Postgres Users Group. See link for details.

Website
Thursday
Sep 18, 2014
PDXPUG: September meeting
Iovation

Portland Postgres Users Group. See link for details.

When: 7-9pm Thu Sep 18, 2014 Where: Iovation Who: Jay Riddle What: Using Postgresql to enable Google like Search

Jay’s been experimenting with Pg’s full text search capabilities. At our next meeting, he’ll cover the following: * Brief intro on why Google like search capabilities are fun. * Introduce Postgresql full text abilities. Discuss at a high level why a full text index may be a bit heavier than a normal index. * Look at possible solutions for use cases where the data you want to index is spread across multiple columns and multiple tables.

Jay Riddle is a database administrator at Viewpoint software.

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

Elevators open at 6:45 and building security closes access to the floor at 7:30.

The building is on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots.

See you there!

Website
Thursday
Oct 16, 2014
PDXPUG: October meeting
Iovation

What: PgOpen Recap (gabrielle, Mark, John M); New Relic Instrumentation of Pg Queries (Andrew)

Please note the new earlier meeting time! We’ll try this over the winter.

Two topics this month: PgOpen attendees will discuss highlights of that conference, and Andrew will talk about some New Relic-y stuff.

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

Elevators open at 5:45 and building security closes access to the floor at 6:30.

Website
Thursday
Nov 20, 2014
PDXPUG: November meeting
Iovation

See website for details.

Website
Thursday
Dec 4, 2014
PDXPUG: December lab night
Renewable Funding

See website for details.

Website
Thursday
Jan 15, 2015
PDXPUG: January meeting
Iovation

When: 6-8pm Thu Jan 15, 2015 Where: Iovation Who: Gabrielle Roth What: RDS Postgres

Amazon integrated Postgres into their general Relational Database Services (RDS) offerings July 1, 2014. RDS offers automatic failover, scalability, and easy configuration, plus Amazon handles all the patching and upgrades for you! Their SDK supports many languages and includes a robust CLI, if you want to automate management of your deployments. They also support several popular Postgres extensions.

Of course, since it’s a managed service, you can’t do everything you might expect or want to. In this talk, I’ll discuss the fun, the quirky, and the downright maddening features I’ve discovered working with production RDS deployments. Come find out what it’s like to use RDS Postgres day-to-day.

The building is on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots.

We’ll go to Huber’s for after-meeting socializing.

See you there!

Website
Thursday
Feb 19, 2015
PDXPUG: February meeting
Iovation

When: 6-8pm Thu Feb 19, 2015
Where: Iovation
Who: David Kerr
What: Using Bucardo to Migrate your Pg database to RDS with minimal downtime

As a followup to January’s RDS discussion, Dave Kerr works through strategies to move your existing Postgres database into RDS.

Using Bucardo and Master/Master Replication we can achieve a migration to RDS with minimal or no downtime.

Dave will show some tools and techniques so help facilitate this transition as well as go over the idiosyncrasies of using Bucardo with RDS.

Website
Thursday
Mar 19, 2015
PDXPUG: March meeting
Iovation Website
Thursday
Apr 16, 2015
PDXPUG: April meeting
Iovation Website
Thursday
May 21, 2015
PDXPUG: May meeting
Iovation Website
Tuesday
Feb 21, 2017
Portland Java User Group: E-commerce under the hood
Oracle (Downtown Campus)

Gilt is an e-commerce fashion retailer. Gilt's application platform leverages popular programming languages such as Java, Scala, Ruby, and JavaScript.

This talk will focus on data persistence strategies in Gilt's core systems: order processing, payment management, invoicing, and checkout. We'll discuss the Event Sourcing pattern and its implementation in a production system.

Speaker:

Sean Sullivan is a Principal Software Engineer at Gilt. Sean has been a member of Gilt's backoffice team since 2011.

Doors open at 6pm for pizza provided by TEKSystems. The presentation will begin at 6:30pm.

slides: https://speakerdeck.com/sullis/e-commerce-under-the-hood

Website
Thursday
Feb 15, 2018
PDXPUG: Automatic For The People
Iovation

Want automated high availability PostgreSQL without relying on someone else's cloud service? It's possible today, and easier than you think; we just need a little container orchestration pixiedust, and your DBAs can take the weekend off.

Josh Berkus will explain the current state of HA Postgres services on Kubernetes/OpenShift, introducing the several projects in this area, and then going into a deep dive on Patroni/Spilo. He'll bring you up to date on the new "Kube-native" Patroni, and work expected in the future. With live demos!


Josh Berkus helps manage the Kubernetes community for Red Hat. He is a "hacker emeritus" for PostgreSQL. He lives in NE Portland with a large black cat, a pottery studio, and a librarian.

Website
Thursday
Mar 15, 2018
PDX Postgres meetup
Iovation

Ahoy database folk! Time for another meetup and more container chit chat. Yeah yeah, you, like me, have heard that you shouldn’t run databases in containers. Well without throwing all caution to the wind, I’m hoping to show you guys some container workflows with Postgres that I’ve been using lately. We’ll talk a bit about why you haven’t been running databases in containers, then walk through some development work flows with Postgres, and lastly look at options for deploying and running persistent databases in containers.

———

Hi, its me Grant Holly. I work at Iovation on the data science and analytics team wrangling our data into visualizations and machine learning models. I live in SE, play in bands, and am a learning machine.

Website
Thursday
Apr 19, 2018
PDXPUG: PUDL: Portland Urban Data Lake
Iovation

Presented by: Dr. Kristin Tufte

This talk will describe work in Smart Cities in the Portland region. We’ll begin with the framework and motivation for the Smart Cities work and the question What is a Smart City? We’ll discuss Portland’s approach to Smart Cities, provide some historical context and then give an overview of ongoing Smart Cities projects including work on AV policy, the Portland Urban Data Lake, new sensors and earthquake resilience. The goal of the talk is to give the audience an overview of the work being done in Portland to bring a human face to data and technology and to inspire question and discussion.

Dr. Tufte is actively involved in Portland’s Smart Cities work and was the data lead on the City of Portland’s Smart Cities proposal. Dr. Tufte has collaborated closely with transportation agencies in the Portland-Vancouver area for the past ten years and directs PORTAL — the regional transportation data archive. Dr. Tufte is a member of the Transportation Research Board’s Urban Data Committee, co-chairing its Urban Big Data subcommittee and Portland Global Cities Team Challenge Action Cluster. Dr. Tufte has a PhD in Database Management from the University of Wisconsin - Madison. Dr. Tufte’s passion is using data and technology to change people’s lives, especially those in traditionally underserved communities.

Website
Thursday
May 17, 2018
PDXPUG May meeting
Iovation Website
Thursday
Jun 21, 2018
PDXPUG June meeting
Iovation Website
Thursday
Aug 16, 2018
PDXPUG: Sneak peek at stored procedures
Iovation

Stored procedure support is coming to PostgreSQL 11. Come hear about what a stored procedure is and how it differs from the existing user-defined functions.

Website
Monday
Sep 10, 2018
Portland PostgreSQL Day (PDXPUG PGDay) 2018
Portland State University Engineering Building

The Portland PostgreSQL Users Group (PDXPUG), Portland State University Maseeh College of Engineering and Computer Science, and Datalab, the PSU Data and Information Management Laboratory and is proud to present a day of presentations about PostgreSQL, an open source relational database management system.

Website
Thursday
Jan 24, 2019
PDXPUG: Bi-Directional Replication for Postgres
New Relic

Note new location and we are meeting the 4th Thursday this month!

pdxpug.wordpress.com

BDR (bi-directional replication) enables asynchronous multi-master replication in Postgres as an extension and has been in full production status since 2014. We will discuss the use cases that BDR is most appropriate for, and where is might not be best suited.

Mark works at 2ndQuadrant as a consultant for English Speaking Territories, based out of Oregon. He is a Contributor to PostgreSQL, co-organizer of the Portland PostgreSQL User Group, and serves as a Director and Treasurer for the United States PostgreSQL Association.

Website
Thursday
Feb 21, 2019
PDXPUG: Temporal Databases: Theory and Postgres
PSU Business Accelerator

Temporal databases let you record history: either a history of the database (what the table used to say), a history of the thing itself (what it used to be), or both at once. The theory of temporal databases goes back to the 90s, but standardization has only just begun with some modest recommendations in SQL:2011, and database products (including Postgres) are still missing major functionality.

This talk will cover how temporal tables are structured, how they are queried and updated, what SQL:2011 offers (and doesn't), what functionality Postgres has already, and what remains to be built.

Paul started programming on a Tandy 1000 at age 8 and hasn't been able to stop since. He helped build one of the Mac's first web servers in 1994 and has founded software companies in politics and technical hiring. He works as an independent consultant specializing in Rails, Postgres, and Chef.

Website
Thursday
Mar 21, 2019
PDXPUG: March Meetup: Let’s talk databases in python!
PDX Code Guild

Speaker: Hannah Stepanek

Let’s talk databases in python! What’s an ORM? Is there a way to write database queries so that they are compatible with multiple types of databases? How do you make database changes (such as adding a new table or a new column) safely? What is a connection pool and why is it useful? What are some things that can go wrong when operating at scale? In this talk we’ll take a deep dive into how the python libraries sqlalchemy and alembic make managing production databases simple, efficient, and painless so you can get back to feature development.

Hannah has been working in industry for over 6 years as a python software engineer. She currently works at Hypothesis, a web application for annotating web pages and pdfs. In her spare time she enjoys riding her horse Sophie and playing board games.

Website
Thursday
Apr 18, 2019
PDXPUG: Postgres with non-blocking IO and Scala
PSU Business Accelerator

Speaker: Grant Holly

This month I will be demonstrating using non-blocking IO database access using Scala and the Slick library. No really, the library is called Slick AND it is very cool to use. Slick and Scala are great for working with Postgres with either straight SQL, or using the FRM (that’s a Functional Relation Mapper like in functional programming). After Hannah gave a great talk talk about Python, Postgres, and ORMs, I got to thinking that I could do a language and ORM talk. Thanks Hannah, that was great.

https://github.com/grantholly/pdx_pug_scala_and_pg

Hi, it’s me still Grant. I work at New Relic as an engineer on the database engineering team. I’ve been using Postgres in production since 9.2 and have been using and enjoying Scala for about two years having worked on a couple of production high throughput applications.

Website
Thursday
May 16, 2019
PDXPUG: Disaster Recovery and High Availability Planning
through PSU Business Accelerator

Learn about the considerations in planning for disaster recovery in order to maintain business continuity. There are solutions available that can help you achieve your backup and recovery objectives by taking advantage of PostgreSQL features, such as point-in-time recovery, and help implement retention policies.

Also learn how to take advantage of PostgreSQL’s replication features to keep your database highly-available, and the basic cluster architectures to consider to keep a PostgreSQL cluster up and running.

Mark works at 2ndQuadrant as a consultant for English Speaking Territories, based out of Oregon. He is a Contributor to PostgreSQL, co-organizer of the Portland PostgreSQL User Group, and serves as a Director and Treasurer for the United States PostgreSQL Association.

Website
Thursday
Jun 20, 2019
PDXPUG Meetup: Accessing Postgres with Java
PSU Business Accelerator

Speaker: Will McLean

To follow the presentations on accessing Postgres from Python and Scala, I will lead a discussion on accessing Postgres with Java. I'll start with a jdbc tutorial and finish with adding data access to a springboot webapp.

I have twenty years experience in e-commerce applications, the last eight here in Portland, mostly at Nike.For the last few years everything has been moving to Amazon RDS Postgres, that's a trend pdxpug can get behind! I am currently working for Navis on CRM applications for the hospitality industry.

Website
Thursday
Aug 15, 2019
PDXPUG August Meetup: PostGIS
PSU Business Accelerator

Jackson will discuss the basics of GIS, and the current environment in which enterprise spatial analytics are performed. Considering the many pitfalls of this current system, he will discuss how FOSS tools – especially PostgreSQL/PostGIS – are vitally important for modern spatial analytics. In addition to the PostGIS extension, Jackson will talk about network routing using the PgRouting extension and the interface between R and PostgreSQL. This talk will act more as a showcase of GIS and “spatial SQL” within PostgreSQL than it will nitty-gritty database development.

Jackson Voelkel is a Health Data Analyst on Kaiser Permanente’s GIS Team as well as an Adjunct Professor of Geography at Portland State University. He focuses on developing infrastructure for and performing advanced spatial analytics across healthcare, environment, urban planning, utilities, and econometrics. He teaches courses on advanced spatial analytics in R as well as spatial database design with PostgreSQL/PostGIS.

Website
Thursday
Sep 19, 2019
PDXPUG: Sharding large MySQL databases with Vitess
PSU Business Accelerator

This month I am going to be talking about my current work on sharding large mysql databases with Vitess. My team has been on a journey towards splitting our largest mysql databases and I want to share my experiences and lessons learned. We are going to look at the problems and possible solutions to scaling reads and writes in relational databases.

Vitess is an open source project born at youtube to scale their largest and most critical databases. It has been adopted in as a Cloud Native Compute Foundation incubator project. With PostgreSQL on the medium-term road map, let’s take a look at what we have been able to do with mysql.

Hi its me Grant. I work on the database engineering team at New Relic. I’ve been using Postgres in production since 9.2. I co-organize the Postgres user group in Portland with Mark Wong.

Website
Thursday
Oct 17, 2019
PDXPUG October Meetup: Terminal Tools & Database Statistics
PSU Business Accelerator

pg_top was born in 2007 from a fork of the unixtop, a terminal program displaying top processes on the system, where pg_top focuses on the processes with the PostgreSQL database you are connected to. Recently pg_systat was forked from systat to display additional database statistics.

These tools have can help do more such as explore query execution plans and create reports from system and database resources.

Come learn about the statistics PostgreSQL keeps and how to use these tools to view them.

Mark leads the 2ndQuadrant performance practice as a Performance Consultant for English Speaking Territories, based out of Oregon in the USA. He is a long time Contributor to PostgreSQL, co-organizer of the Portland PostgreSQL User Group, and serves as a Director and Treasurer for the United States PostgreSQL Association.

Website
Thursday
Jan 16, 2020
PDXPUG: Interacting with databases as API's
Portland State Business Accelerator

Speaker: Alex Theodore

As a CTO I saw everything that went into and came out of the web development process, from the "client needs" to the source-controlled code. But being skilled in database development showed me time and time again that databases (and their architecture) were often sidelined treated as after-thoughts and often times served as little more than flexible storage spaces. Yet, their contents were the very essence of value for the process/client/company being served. This strange inversion of priorities led me to develop a way of looking at databases as "outside" the application and ultimately to interacting with them as API's. In my talk I'll be presenting this concept and showing with simple rules and examples how it can be done.

Bio:

I was the product and technology founder of Fracture.me and CTO up until 2018 where I developed the manufacturing processes and ERP software that powered our production process. That got me deeply involved in database work, especially with architecture and process design and optimization. Now I work part time as a database consultant and part time building modern, minimalistic furniture for my new (small) company MillFinish.com.

Website
Thursday
Feb 20, 2020
PDXPUG February 2020 Meetup: DBlink and SQL/MED and FDW, oh my! External Data Access tricks
PSU Business Accelerator

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.

Website
Thursday
Apr 23, 2020
PDXPUG: Multiranges and SQL:2011 Temporal Features
Online

We are using Meetup.com to distribute the link to the online meeting [1], which will be set shortly before the meeting as we will be using Jitsi [2]. Meetup does require you to RSVP to get access to the link. 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.

[1] https://www.meetup.com/pdxpug/events/270062132/ [2] https://jitsi.org

Website
Thursday
Jan 19, 2023
PDXPUG: What's new in PostgreSQL 15 (Note last minute venue change.)
PDX Code Guild

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.

Website
Thursday
May 18, 2023
PDXPUG MeetUp: Django and Postgres
PDX Code Guild

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 with the group. This talk is for all levels of experience from “I just heard about Django” to “We run production Django”, from “oh Postgres, that’s the elephant one right?” to “Ask me anything about Postgres”.

We will also have zoom link available closer to the presentation date if you want to attend remotely. Sign up on MeetUp for this notification: https://www.meetup.com/pdxpug/events/293519969/

Website
Thursday
Jun 15, 2023
PDXPUG: SQL Antipatterns
PDX Code Guild

Few abstractions and tools have proved as enduring in the field of Computer Science as the relational database model. Due to the diligent efforts of the Postgres team, the Postgres project has an ever increasing popularity in the software world and a fully modernized feature set. One effect of the longevity of the project has been to create a deep pool of received wisdom regarding the use and misuse of Data Models and SQL. Revisit some of the wisdom from a classic of the genre: SQL Antipatterns: Avoiding the Pitfalls of Database Programming by Bill Karwin, with updated opinions and commentary to modernize the material. Stay after for pizza and a rousing exchange of ideas on the past, present, and future of SQL and of the Postgres project.

Speaker: Joseph Hammerman

Joseph Hammerman is a Linux Systems Administrator and Database Reliability Engineer with 18 years of experience. For the last 10 years that work has focused on Postgresql database reliability and High Availability engineering practices. Some career highlights include: serving on the iHeartRadio launch team, working at SecondMarket prior to and during their acquisition by NASDAQ Private Markets, and founding and serving on the Squarespace Database Reliability Engineering team. He is currently employed as Technical Lead for the DataDog Postgresql database reliability engineering team. He is a passionate advocate of Free and Open Source software and the ideals that it embodies.

Website
Thursday
Aug 17, 2023
PDXPUG: Developing Your Own Database Extensions
WeWork

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 and getting started authoring your very own first database extension! Time permitting, and with interest, we will cover operators and types. This talk is intended for all developers and DBA’s alike, so bring your questions. If you have a favorite extension, we want to know, so bring it to the discussion. I’ll go first: favorite extension: most flavors of FDW’s for sure.

Now a bit about Jerry. He’s currently working at Hydra (https://hydra.so/) on data warehousing with Postgres, but has been using Postgres for waaaay too long. If you’ve ever used PLJS (https://github.com/plv8/pljs), he’s the author, and he is the maintainer of PLV8 (https://plv8.github.io/).

Website
Thursday
Nov 2, 2023
PDXPUG: What's new in PostgreSQL 16
American Red Cross

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 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.

Note that this will be the last PDXPUG meeting of the year until 2024.

Website
Thursday
Feb 15
PDXPUG: Zero Downtime: Live Data and Server Migrations
American Red Cross

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. Please bring your own stories and questions and add to the conversation.

Website