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

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


Hans-Jürgen Schönig