Re: [GENERAL] query creates a huge toast tables

2013-12-09 Thread Steve . Toutant
t;pgsql-general@postgresql.org" Objet Re: [GENERAL] query creates a huge toast tables On Thu, Nov 28, 2013 at 8:25 AM, wrote: Hi, This query (postgis) didn't endup after 4 hoursand eat 40gig of disk space SELECT id, gridcode, ST_Difference(a.geom32198_s,b.geom32198_s) as geom3

Re: [GENERAL] query creates a huge toast tables

2013-12-02 Thread Jeff Janes
On Thu, Nov 28, 2013 at 8:25 AM, wrote: > > Hi, > This query (postgis) didn't endup after 4 hoursand 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 t

[GENERAL] query creates a huge toast tables

2013-11-28 Thread Steve . Toutant
Hi, This query (postgis) didn't endup after 4 hoursand 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