I'm pretty sure that the optimisation barrier is a 'feature'. This can actually ...

keeperofdakeys on Dec 30, 2015 | parent | context | favorite | on: Postgres features and tips

I'm pretty sure that the optimisation barrier is a 'feature'. This can actually be handy, especially when replacing a complex subquery that the query planner turns into a nested loop.