A Postgis view was created with a query that executes in about one second.
It is a parcel layer composed of about 20,000 polygons (the original layer loads without any problems).
When loading this view in QGIS 2.14 the geometry loads quickly enough (perhaps a few seconds longer than a regular table), but when viewing attribute table, QGIS fails to respond, freezes for a few seconds, and then shows the table. However, it is not possible to scroll through the table as it freezes or simply does not respond to mouse clicks.
At this point I will have to abandon the use of views since the performance is terrible, unless I'm doing something wrong on the QGIS or DB side.
Is there a way to improve the performance of PostGIS views in QGIS 2.14?