PGCon2014 - Final Release

PGCon 2014
The PostgreSQL Conference

Samantha Billington
Day Talks - Day 1 - Thu May 22 - 2014-05-22
Room Morisset 221
Start time 14:00
Duration 00:45
ID 726
Event type Lecture
Track Scaling Out
Language used for presentation English

Mission Impossible

Scaling a 100% Cloud Native Analytics Engine

Your mission, should you chose to accept it, create a data storage system that can handle 200 Gigs of data per day on cloud servers with heavy analytics. GO!

The architecture plan of a real time logging system built to handle 200g/day of data and hand it off from mid-term OLTP storage into and OLAP postgres data warehouse. It was built with heavy reliance on inheritance, dblink, and streaming replication.