Run ST_IsValid and ST_MakeValid to clean "dirty" geometry on the fly.
For massive, chronologically sorted datasets (like GPS pings), BRIN indexes are much smaller and faster than traditional GiST indexes.
Link external files (GeoJSON, Shapefiles, CSVs) as virtual tables without importing data.