PDXPUG: April meeting in two weeks

When: 6-8pm Thursday April 21, 2016
Where: Iovation
Who: Eric Ferreira, Database Engineer, Amazon Web Services
What: How to hide a petabyte-scale Data warehouse inside a small OLTP database

You may have heard that Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse. You’ve heard that it’s a shared-nothing cluster architecture, that it scales to hundreds of nodes and terabytes, and that it’s “based on Postgres”. How is that combination possible, and how much of Postgres survived that transformation? Eric Ferreira, who was the first engineer to work on Redshift, will discuss the design, tradeoffs and modifications made to make Redshift the scalable system it is today. Bring your questions!

We will also talk about ways to mix and match Postgres (OLTP) tables and Redshift (DW) tables on a single connection using pgboucer-rr and Postgres external data sources.

Eric started in the database world 26 years ago in Brazil and has implemented most flavors of RDBMS thought his career. He joined Amazon on 2003 and while on AWS/RDS worked on bringing various databases engines into the service. 5 years ago he ventured to start the project that would become Redshift.


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!

(You can RSVP on our meetup group, if you like.)

Advertisements

PDXPUG: March meeting in two weeks

When: 6-8pm Thursday Mar 17, 2016
Where: Iovation
Who: Josh Berkus
What: Big Data on Pg 9.5

PostgreSQL 9.5, released in January, is full of tasty goodness for big data folks: UPSERT, new aggregation types, OLAP support, new Foreign Data Wrapper functionality, BRIN indexes, and more. Josh Berkus will give us a rundown of these features, with multiple demos.

Josh Berkus is a member of the PostgreSQL Core Team, and works at Red Hat where he manages the Project Atomic community. Containers, containers, containers! Which is appropriate, since he’s also a potter.


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: August meeting

When: 7-9pm Thu Aug 21, 2014
Where: iovation
Who: Jim Newman, iovation
What: Elasticsearch & Postgres, a working relationship

Topics to be covered:
– A brief intro to Elasticsearch
– Indexing Postgres with Elasticsearch using the JDBC river plugin
– SQL versus the Elasticsearch Query DSL, similarities (there are some) and differences
– Using Postgres Perl functions for some SQLish access to Elasticsearch
– Feasibility of a foreign data wrapper for Elasticsearch?, pg2elasticsearch is still just a GitHub readme

Jim Newman has 30 years of assorted database-related activity and shooting pool. He’s currently employed as Principal Data Architect at iovation.

This month we get to try yet another meeting location while the iovation offices are being renovated. We’re still in the US Bancorp Tower at 111 SW 5th (5th & Oak), but we’ll be in the iovation temporary office on the 36th floor, in the “West Hills” conference room. Once off the elevator, enter through the door with the small “iovation” sign, then just go right and keep right until you hit a dead end, which is where “West Hills” is. Signs will be posted.

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: August meeting

When: 7-9pm Thu Aug 18, 2011
Where: FreeGeek
Who: Rob Wultsch
What: Lessons Learned From Managing Way Too Many Database Servers

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!

PDXPUG: February meeting

Our February meeting is in two days! This marks the second entry in our “Founders Series”.

When: 7-9pm Thu Feb 17, 2011
Where: FreeGeek
Who: Selena Deckelmann
What: Maintaining Terabytes: 10 Things to Watch Out For When PostgresSQL Gets Big

Join us for a special members-only preview of the talk Selena will be giving at MySQLConf.

You can read all about Selena’s talk here:
http://en.oreilly.com/mysql2011/public/schedule/detail/17195

Beer afterwards at the Lucky Lab. See you there!

February Meeting 2/18/2010: Over Normalization from a developers point of view

Ben Hengst will be speaking at the next PDXPUG meeting at FreeGeek (at 7:00pm – 1731 SE 10th Avenue, Portland, OR).

—–

Ben Hengst works for Powells.com and has been involved in some in house restructuring, mostly centered around moving to a very vertical structure. This talk will revolve around what works and what doesn’t, code and people problems that have been encountered and how to dig your self out.

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

Next Meeting: March 20, 2008

TOPIC: Managing internet services: using the right tool for the job
SPEAKER: Ed Sawicki
WHEN: March 20, 2008, 7pm
WHERE: FreeGeek, 1731 SE 10th Ave, Portland, OR 97214

Also: What the heck is the United States PostgreSQL Association?, Selena Deckelmann

AND: ELEPHANT BUTTONS! courtesy of David Fetter.

Here’s what Ed had to say about his presentation:

“I’ll probably end up doing live benchmarks, showing code snippets, and explaining my rationale for why I chose
to do things the way I do.

“My current projects involve managing a variety of Internet services, such as spam suppression and the associated per-user black/white list management, DNS record management, PKI key management, and a variety of others. Some of these services require that I deal with the storage and retrieval of both discrete IP addresses and CIDR blocks in real time.

“I’ve had to decide on data stores that include plain text files, SQL using SQLite and Postgres, and constant databases using tinycdb. At every stage of development I’ve had to decide which of these was best based on tools available and performance testing. For example, Postgres has IP and CIDR data types and adequate facilities to search for IP addresses within a CIDR block but performance pales in comparison to simpler tools that use plain text files. As a result, my applications use various data stores instead of just one.””

Refreshment afterward at the Lucky Lab!