On Thu, Nov 28, 2013 at 8:25 AM, <Steve.Toutant@xxxxxxxxxxx> wrote:
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"
Cheers,
Jeff
