Hi, This query (postgis) didn't endup after 4 hours....and eat 40gig of disk space SELECT id, gridcode, ST_Difference(a.geom32198_s,b.geom32198_s) as geom32198_s into potentialite FROM province as a, potentialite_tmp as b;
I stopped the execution and cancel request sent appears, but after an hour the request wasn't stopped yet. So I killed the process and restat postgres.
The database is up and running but I didn't get the 40gig of disk space back. And only 5gig remains on the server
It is this table that is so huge pg_toast.pg_toast_11037520
What table (if any) does it belong to? "select relname from pg_class where oid=11037520"
