On Thu, Nov 28, 2013 at 8:25 AM, <steve.tout...@inspq.qc.ca> 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
