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!