Normally the following SQL Command takes a couple of minutes:
SELECT
AX14004X11003_ID, polygons.objid, points.objid
from
polygons
join points
on ST_Touches(points.shape, polygons.shape) or ST_Within(points.shape, polygons.shape);
After I have updated my PostgreSQL from Version 10 to 13, the same statement with the same database takes 11 hours. Additionally, the PostGIS Version changed from 2.5.1 r17027 to 3.2.0 3.2.0.
Are there any changes in the newer versions that would explain why it takes 11h for this particular command? Does anyone have an idea what the problem might be? The database is exactly the same...