Schedule - PGConf.EU 2014
Data analysis
Date: 2014-10-21
Time: 09:00–12:30
Room: Renacimiento I
Level: Intermediate
This training covers important aspects of data analysis such as aggregations, analytics and windowing as well as extending PostgreSQL with additional functionality. Performance aspects will be discussed as well. Content:
- Importing data efficiently
- (COPY FREEZE, COPY FROM ... etc.)
- Hint bits and VACUUM related issues
- Indexing large scale data efficiently
- (maintenance_work_mem, etc.)
- Simple aggregations
- Windowing functions
- Windowing vs. aggregations
- Writing custom aggregates
- Optimizing custom code
- Scaling out analytics
