I'm working with large PostGIS tables in QGIS but really only need to do simple visualization and editing the attributes (like change road names, speed limits, etc). The most processing I need to do is just a simple join by attributes between a couple tables. The large datasets are about 400 MB.
Are there ways to speed up things loading the attribute table and rendering the map? If not, are there any other good GIS software designed to handle bigger datasets? Or is it really just an issue of optimizing my network connection and postgres database?