Re: query creates a huge toast tables

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(dot)janes(at)gmail(dot)com>
2013-12-02 18:23

A
Steve(dot)Toutant(at)inspq(dot)qc(dot)ca
cc
"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Objet
Re: [GENERAL] query creates a huge toast tables

On Thu, Nov 28, 2013 at 8:25 AM, <Steve(dot)Toutant(at)inspq(dot)qc(dot)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