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!

PDXPUG: May meeting in two weeks

When: 6-8pm Thursday May 21, 2015
Where: Iovation
Who: You!
What: Short talks

We’ll be having 2-3 short sessions for this month’s meeting. I’ll talk about crosstab and Michelle will tell us about getting Pg to work with Sensu. We have room for one more, so if you have something you’d like to discuss, let me know.

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.

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!

PDXPUG: April meeting next week

When: 6-8pm Thursday April 16, 2015
Where: Iovation
Who: Eric Hanson
What: Aquameta release!

Eric Hanson will give a tutorial for how to build applications with Aquameta, an open source web development platform built entirely in PostgreSQL. Aquameta is about to be launched as open source, so we’ll do a quick launch recap, and then dive into the tutorial.


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.

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!

PDXPUG: March meeting next week

When: 6-8pm Thursday Mar 19, 2015
Where: Iovation
Who: Ed Snajder
What: Creating an auto-partition strategy

Table partitioning is a great way to reduce cost and IO on very large data sets, very often with analytics-type databases and systems that collect historical data. While Postgres does offer table partitioning and the advantages that go with it, the care and feeding of partitioned systems can be tedious and error-prone, and Postgres does not offer a lot of built-in tools to help to reduce administrative overhead.

Ed will share his approach to tackling this, with a set of functions that will take an existing table, create partitions on it, and ultimately migrate the data. He’ll also, time permitting, compare to the more mature pg_partman.

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.

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!

PDXPUG February Meeting Recap

Mark & I left David Wheeler in charge of the PDXPUG February meeting while we were at SCALE last week.

Here’s David’s report:

This week Dave Kerr discussed using Bucardo mutli-master replication to gradually migrate a production database from EC2 to RDS. This work allowed his team to switch back and forth between the two systems with the assurance that the data would be the same on both. It also allowed them a fallback in case the RDS database didn’t work out: the S3 system would still be there. The discussion allowed those present to complain about Bucardo, EC2, RDS, and the French.

Thanks!

PDXPUG: February meeting in two weeks

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.

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.

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!