> I think it would be more accurate to say that (AFAICT) Postgres doesn't currently have any way to extend the optimizer with custom plans (though it's been a very popular feature suggestion).

There's http://www.postgresql.org/docs/devel/static/custom-scan.html