Re: query creates a huge toast tables
| От | Steve.Toutant@inspq.qc.ca |
|---|---|
| Тема | Re: query creates a huge toast tables |
| Дата | |
| Msg-id | OF97A3E3C2.54F1F517-ON85257C3C.005751B4-85257C3C.0057592F@isn.rtss.qc.ca обсуждение исходный текст |
| Ответ на | Re: query creates a huge toast tables (Jeff Janes <jeff.janes@gmail.com>) |
| Список | pgsql-general |
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@gmail.com> 2013-12-02 18:23 |
|
On Thu, Nov 28, 2013 at 8:25 AM, <Steve.Toutant@inspq.qc.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
В списке pgsql-general по дате отправления: