Search Postgresql Archives

Re: query creates a huge toast tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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.janes@xxxxxxxxx>

2013-12-02 18:23

A
Steve.Toutant@xxxxxxxxxxx
cc
"pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
Objet
Re: query creates a huge toast tables







On Thu, Nov 28, 2013 at 8:25 AM, <Steve.Toutant@xxxxxxxxxxx> 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux