Time: 13:30 - 17:00
In this interactive course, we will develop a simple custom aggregate. In doing so, we will learn how to write a PostgreSQL module in C and how to package it up into an extension.
Along the way, we will learn how to adapt our aggregate example for the "moving-aggregate" optimization introduced in 9.4, and how to make our custom aggregate usable by the parallelization infrastructure new in 9.6.
We will also look at considerations for making it work with PostgreSQL XL.