The videos for FOSS4G NA 2016 have started coming out. Recently Andrea Ross posted PostGIS Spatial Tricks talk video. I'm happy to say it looks pretty good and I didn't suck as badly as I worried I would. Thank you very much Andrea. Some talks unfortunately did not come thru. I'm hoping Leo's pgRouting : a Crash Course video made it thru okay as well, and will post that later if it does.
Only small little nit-picks is the first 2-5 minutes or so didn't make it thru and the blue colors on the slides got a little drowned out, but here are the slides if you need full resolution.
Update since the talk. The parallelization work has been committed to PostGIS 2.3 repos and mirrors. We are in the middle of testing this feature with PostgreSQL 9.6 beta1 and also flagging more functions like some of the raster functions as PARALLEL SAFE and adding relevant costs. Many thanks to Paul Ramsey for pushing this through. For the most part, geography and geometry have already been flagged as PARALLEL SAFE where it's possible for them to take advantage of these features. Paul Norman also helped by computing costs for many geometry functions.
