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