It would be very educational to see the original querys with plans and the new ones with plans to see what's going on. Surprisingly I did not see that the views in PostgreSQL has inefficient plans at all, compared to Oracle.