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
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
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