You will eventually run out of memory or some other restraint given large enough datasets. PostGIS will churn through it and not crash...