Re: query creates a huge toast tables
| От | Jeff Janes |
|---|---|
| Тема | Re: query creates a huge toast tables |
| Дата | |
| Msg-id | CAMkU=1yA=cb1hB8F-crorOCuVVcjjXQPWk1NPv69z6Dth4AXJQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | query creates a huge toast tables (Steve.Toutant@inspq.qc.ca) |
| Ответы |
Re: query creates a huge toast tables
|
| Список | pgsql-general |
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 по дате отправления: