PDXPUG: January meeting

NOTE: This month’s meeting is one week earlier than our usual schedule, so we don’t conflict with SCALE.

When: 6-8pm Thursday January 14, 2016
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 most of the 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. We’ll discuss the fun and quirky features I’ve discovered in a year and a half of working with production RDS deployments. Come find out what it’s like to use RDS Postgres day-to-day.

(This is an updated version of my talk from last year. )

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 co-leads PDXPUG, the Portland PostgreSQL Users’ Group. Gabrielle’s current areas of interest are monitoring, benchmarking, and writing freaky SQL.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

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.

When you arrive at the Iovation office, please sign in on the iPad at the reception desk.

See you there!

PDXPUG: November meeting in two weeks

PDXPUG:  November meeting

When: 6-8pm Thursday Nov 19, 2015
Where: Iovation
Who: Andrew Kreps
What: Postgres, JSON, ChatOps, oh my!

Andrew will show us real-world example of how to use JSON fields in Postgres to create chat-room based bots.  (I expect this will be just as entertaining as his last presentation.)

Andrew’s a Portland-based software engineer who digests APIs for breakfast. After stumbling through the worlds of Oracle and Mysql for many years, he’s found PostgreSQL to do things they way they should have always been done.

If you have a job posting or event you would like me to announce at the meeting, please send it along.  The deadline for inclusion is 5pm the day before the meeting.

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.

Iovation has a new policy for visitor sign-in. Please do so on the iPad at the reception desk when you arrive.

See you there!

PDXPUG October meeting in two weeks

When: 6-8pm Thursday October 15, 2015
Where: Iovation
Who: Gavin McQuillan
What: Sharded Postgres with PLProxy

Data of Future Past: Postgres as Distributed Online Processing Analytics Engine

Postgres has long been a great analysis tool, but as organizations seek to decentralize their data, it’s overlooked for other solutions. Maybe this doesn’t need to be the case. Using a novel combination of tools, old and new, Postgres can also decentralize its data. We can maintain the immensely powerful interface that we love, while meeting (or exceeding) throughput decentralized datastores provide. In this talk we see how this is possible using Foreign Data Wrappers (PLProxy) and HyperLogLog (Postgres-HLL) extensions, detailing benefits and constraints to this method. We explore a reimplementation of a complex Online Processing Analytics hypercube in Hbase with Postgres and measure its effectiveness, throughput, latency, and cost savings.

Gavin is a longtime PostgreSQL enthusiast, specializing in building automation and analytics solutions, distributed systems, scaling and securing web applications. His experience includes Google SRE, software development and leading teams in young technology startups. He lives in Portland with his family, bicycles, and hand planes.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

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.

See you there!

PDXPUG: September meeting next week

When: 6-8pm Thursday Sept 17, 2015
Where: Iovation
Who: Eric Hanson
What: 10 examples of datafication

Eric, our resident data philosopher and CEO of Aquameta, will talk and give demos on 10 examples of Datafication, including the raspberry pi FDW!

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.

See you there!

PDXPUG: August meeting

When: 6-8pm Thursday August 20, 2015
Where: Iovation
Who: Robert Berry
What: Record Linking (entity resolution)

In this presentation we will grapple with the un-joinable itself, and see if we may not join it after all. The presentation explores the record linking problem (entity resolution) in the context of PostgreSQL. This problem generally arises when you have multiple data sources (or duplicates) without a reliable key to resolve multiple records to the same entity. First the problem is explored, then a general approach to developing a solution is presented, and finally there will be some pro tips.

Robert is a digital janitor. He consults/contracts in Portland to help companies in search of improved data quality.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

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.

See you there!

PDXPUG – July meeting – OSCON BoF Session

When: 7-8pm Wed July 22
Where: Oregon Convention Center, Room E141

We’re having a Birds of a Feather session at OSCON instead of our usual July meeting.

We’ll be talking about 9.5 features – I have a list of my five faves to get the conversation started; please BYO if you’d like to participate! (It’s ok to just show up, of course:) )

Registration is not required to attend the BoF. O’Reilly would prefer we register, though – here’s a code for a free pass if you would like to also check out the Expo Hall: https://twitter.com/oscon/status/621013720257269760

PDXPUG: June meeting next week

When: 6-8pm Thursday June 18, 2015
Where: Iovation
Who: Mark Wong
What: Pg Performance

Come have a chat with our local performace expert, Mark Wong.

This presentation will take a look at the performance changes in the development version of PostgreSQL. A selection of features, some proposed and some already committed, are evaluated using synthetic open source workloads. One of the workloads used is the former OSDL’s Database Test 3 that consists of business oriented ad-hob queries with concurrent data modification.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). Due to fire alarm testing at our regular location, we’ll be meeting in the main Board Room of the US Bancorp Tower, 111 SW 5th. (We’ll have signs up in the lobby to guide you.) 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!

See you there!