This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2018

Architecting real-time analytics for your customers

Date: 2018-10-23
Time: 13:30–17:00
Room: Munich
Level: Intermediate

We'll cover various schema designs for ingesting large amounts of data (millions of records per second), how to perform rollups of data both in order and out of order, how to bucket rollups so they're composable, and finally some various sketch algorithms and datatypes that can be valuable for these type of applications such as TopN and HyperLogLog. We'll spend most of our time in SQL including scheduling our jobs to do all the heavy lifting directly in the database with pg_cron. Finally we'll look at how we can further scale this our and parallelize the workload for better performance with Citus.


Craig Kerstiens
Marco Slot