The following performance tests were peformed on a i7-6920HQ CPU @ 2.90GHz, using raster 2.6-7, PostgreSQL 9.5 and PostGIS 2.2. See here for the underlying R script.
raster