What’s a Chelnik, you ask?

PDXPUG’s official logo is a mask-wearing Slonik:
pdxpug_logo

Hir name is Chelnik. Sort of like Slonik, but different.*

A couple years ago, my co-leader Mark Wong starting making amigurumi, little crocheted stuffed animals. I think he started with Angry Birds, but pretty soon after, he made a Chelnik (the one in the banner on this blog, in fact). And then another…

He took one to PgCon 2012, and donated it to the charity auction, where it netted $500 for The Ottawa Mission.

To date, Mark’s made a dozen of these elephants for sale or auction at various Pg conferences, raising money for donations to the following organizations:
PGUS ($350), The Ottawa Mission ($680), Chicago Hopes ($640), and most recently at PGConf NYC, $1200 for Heartsong.

Thanks to Mark and everyone who’s participated in these auctions.

stowaway_cropped

* No, it doesn’t really mean anything. Beer was involved in the naming.
There’s a tumblr with some photos of the various Chels he’s distributed.

PDXPUG: April meeting this week

When: 7-9pm Thu April 17, 2014
Where: Iovation
Who: Brian Panulla
What: Intro to Graph Databases

Brian Panulla is a Business Intelligence Developer at Acureo. He’s been fulfilling PDXPUG’s rhombic triacontahedron needs for over a year. Next week, he’ll be giving us an Intro to Graph Databases!

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!

Building security will close access to the floor at 7:30.

See you there!

PDXPUG: March meeting in two weeks

When: 7-9pm Thu Mar 20, 2014
Where: Iovation
Who: Mark Wong
What: An Adventure in Data Modeling: The Entity-Attribute-Value Model

Emma, Inc. is an email marketing company that provides a Web based
application for managing email lists and marketing campaigns. This is a
tale about Emma’s experience with a database schema design refactor that
is now using the Entity-Attribute-Value (EAV) data model on the members
in email lists. We will briefly describe the previous data model and
why we had to move to a new one. This is followed by all the places
where Emma stumbled and recovered in implementing the EAV data model and
rebuilding the application around it. Finally we will touch on where
Emma might go next with respect to the data.

Mark is a Data Architect at Emma, Inc. and works with their PostgreSQL
database systems.

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!

Building security will close access to the floor at 7:30.

See you there!

Streaming Rep Lab Part 2 – recap

We had our Streaming Rep Lab followup last night1. It was mostly successful: half of the new people got it up & running, and the people who’d been at the previous workshop got to experiment with almost everything on the agenda.

The cheatsheet is up on our git repo: https://github.com/pdxpug/cheatsheets 2.

We talked a bit about monitoring and messed around with some of the available functions (e.g. pg_last_xact_replay_timestamp), started looking at pg_xlogdump (for “educational purposes”, of course), checked out a packet capture between the master & standby, and finished up with breaking the link between the master & the standby: the standby cried a bit about not being able to reach the master, but as soon as we restored the link, everything was fine.

The overarching theme of the evening is that we need to come up with a more robust plot to make Postgres fail in an interesting way.

SELECT pg_last_xact_replay_timestamp(); will give you a WAL ID, but is only valid on a standby.
The function to translate it to a file name: SELECT pg_xlogfile_name([id]); can only be run on the master. So that’s kinda weird and requires some puzzling out.

I started a wiki page of ideas for future labs, but we may be hung up on streaming rep & breaking it for a little while :)

Thanks to Emma for hosting & providing dinner!



1 – With a puppy.
2 – Yes, I know there is something wrong with the step numbering. It renders correctly in github’s md validator, but not when I upload it.

Streaming Rep Lab, Part 2 – two weeks from today

When: Thu Feb 27, 6pm-9pm (light dinner provided)
Where: Emma, B-side 6 Building, 5th floor

This is in addition to our regular monthly meeting, which is next week.

We didn’t quite get everything covered last time, so we’re having a followup lab to:
- practice recovery (which means we’ll be breaking it :) )
- discuss monitoring options
- check out the human-readable WAL

You are welcome to attend if you couldn’t make the first lab. We’ll have a quick review of what we did, but won’t be spending too much time on it. As with the previous lab, there is no set schedule or exercises – we’ll make it up as we go.

Please come prepared with a laptop with the SR setup of your choice. Bonus points if it’s broken and we need to troubleshoot it. (SR, not your hardware.)

Space is limited, so please sign up in advance:

PDXPUG: February meeting

When: 7-9pm Thu Feb 20, 2014
Where: Iovation
Who: Dave Kerr
What: Monitoring Postgres at New Relic

You already know that New Relic can give you really good insight into your
applications. But how about your PostgreSQL database?

Join Dave Kerr as he shows that New Relic isn’t just for developers anymore!
We’ll demo using New Relic’s system monitoring along with its plugin system
where you can get in-depth database information such as slow queries,
number of backends, checkpoint info – just about everything a DBA needs!

Dave Kerr is a recovering DBA, PostgreSQL evangelist and is currently working
as a Software Engineer on the Site Engineering team at New Relic.

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!

Building security will close access to the floor at 7:30.

See you there!

[PDXPUG] Streaming Rep Saturday Recap

6 folks turned out for our first Streaming Replication lab day. Here’s what we accomplished:

- lively discussion about the different pieces involved (WAL files, various GUCs, etc)
- worked on a step-by-step cheatsheet
- got sr running between two vms, between two Pg instances on the same VM on different ports, and between two Pg instances on the same VM via unix sockets
- learned some new tools (terminator, anyone?)
- spread the \e love

There will be a followup to this lab, as we didn’t cover everything we wanted to, and (of course) created more questions for ourselves.

Thanks to everyone who attended for taking time to hang out inside on a sunny day, and to EDB and Emma for lunch and facilities!

Our next regular meeting will be Thursday Feb 20th; watch for the announcement next week.

PDXPUG: January meeting

When: 7-9pm Thu Jan 16, 2014
Where: Iovation
Who: Peter Geoghegan
What: “Something UPSERT-y”

Peter Geoghegan, currently an engineer at Heroku, has made a number of notable contributions to PostgreSQL:
- Modifying pgstatstatements, the contrib module that logs frequently executed queries, to support the normalization of non-prepared queries.
- Contributing a performance optimization to PostgreSQL 9.2, with which the sorting of scalar types like integers has been considerably sped-up. This has been observed to result in an over 30% performance improvement in execution time for some simple queries with ORDER BY clauses, an improvement that holds up well as the size of the underlying table grows.
- Introducing a series of changes to PostgreSQL to improve its power consumption when idle, by eliminating the busy-waiting that previously prevented CPUs from entering idle states.

Peter’s going to talk about his work on UPSERT and logical replication.

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!

Building security will close access to the floor at 7:30.

See you there!