There's already a lot of Postgres-specific 3rd party modules. This kickstarter is exactly about integrating some of those into contrib.