I was faced with interesting problem. Which schema, in my DB, uses the most disk space? Theoretically it's trivial, we have set of helpful functions: pg_column_size pg_database_size pg_indexes_size ...

On 8th of December, Simon Riggs committed patch: REINDEX SCHEMA Add new SCHEMA option to REINDEX and reindexdb. Sawada Masahiko Reviewed by Michael Paquier and Fabrízio de Royes Mello

On 10th of July, Tom Lane committed patch: Implement IMPORT FOREIGN SCHEMA. This command provides an automated way to create foreign table definitions that match remote tables, thereby reducing tedium and chances for error. In this patch, we provide the necessary core-server infrastructure and implement ...

On 8th of February, Tom Lane committed patch: Core support for "extensions", which are packages of SQL objects. This patch adds the server infrastructure to support extensions. There is still one significant loose end, namely how to make it play nice with pg_upgrade, ...

Absolutely great post about designing database schema to contain information about marriages and partnerships with emphasis on changes brought to us by modern day - gay marriages, non-trivial sex/gender identities and polygamy.