Re: PDXPUG: April meeting in two weeks

For those who would like to read up beforehand - the "mix and match"
Postgres and Redshift is described here:
https://blogs.aws.amazon.com/bigdata/post/Tx3G7177U6YHY5I/Query-Routing-and-Rewrite-Introducing-pgbouncer-rr-for-Amazon-Redshift-and-Postg

On Thu, Apr 7, 2016 at 6:58 PM, Gabrielle R <gorthx(at)gmail(dot)com> wrote:

> 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!
>