I gave a talk at the PG Conf US 2017 titled “Columns and Clouds” that covered PostgreSQL partitioning, foreign data wrappers, using column store (c-store) and remote cloud based partitions.

Columns and Clouds Partitioning in PostgreSQL

The Slides (in PDF) for the talk are here.