PDXPUG: October meeting in two weeks

When: 6-8pm Thursday October 15, 2015
Where: Iovation
Who: Gavin McQuillan
What: Sharded Postgres with PLProxy

Data of Future Past: Postgres as Distributed Online Processing Analytics
Engine

Postgres has long been a great analysis tool, but as organizations seek to
decentralize their data, it’s overlooked for other solutions. Maybe this
doesn’t need to be the case. Using a novel combination of tools, old and
new, Postgres can also decentralize its data. We can maintain the immensely
powerful interface that we love, while meeting (or exceeding) throughput
decentralized datastores provide. In this talk we see how this is possible
using Foreign Data Wrappers (PLProxy) and HyperLogLog (Postgres-HLL)
extensions, detailing benefits and constraints to this method. We explore a
reimplementation of a complex Online Processing Analytics hypercube in
Hbase with Postgres and measure its effectiveness, throughput, latency, and
cost savings.

Gavin is a longtime PostgreSQL enthusiast, specializing in building
automation and analytics solutions, distributed systems, scaling and
securing web applications. His experience includes Google SRE, software
development and leading teams in young technology startups. He lives in
Portland with his family, bicycles, and hand planes.

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

See you there!