Hi Jeff This query returns "tmpcarteprotection4" tmpcarteprotection4 is old and useless, it could be dropped. Before dropping it is there something else I should do? Thank you very much for your help Steve
Jeff Janes <jeff.ja...@gmail.com> 2013-12-02 18:23 A steve.tout...@inspq.qc.ca cc "pgsql-general@postgresql.org" <pgsql-general@postgresql.org> Objet Re: [GENERAL] query creates a huge toast tables 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