within a python application a uge PostGIS geometry table (Polygon) is polled for certain processing. Yesterday we have set our testing system back to an earlier snapshot and failed to notice that this application still used the table on our testing system. So we have lost some million records of much more million records. No we want to visualize the remaining 26 million records to evaluate the 'damage'. We tried PostGIS Layer in QGis (no chance), export to shape or GML (no chance, 28GB GML file), export to GTiff (aborted), we tried to union to reduce number of geometries (query is still running after 2 days) ... Is there a method out there to 'quick' visualize such an amount of data? Our testing system is running on a server so we can add additional processors and RAM if needed.
Any help is welcome.