:) Hi kjt,
Actually, 21000 is a very small table. There are spatial tables out
there with 1/2 billion rows.
You shouldn't be getting an out of memory error on such a small table.
What happens if you try to restructure your query, like:
UPDATE kecskemet_k.foldreszletek AS t
SET hrsz=f.szoveg
FROM kecskemet_k.feliratok f
WHERE t.geometria && f.geometria
AND intersects( t.geometria, f.geometria )
AND f.reteg IN ( '11' );
If you still get an out of memory error, let us know of your machine's
specs and Postgres settings, like shared_memory, work_mem, etc.
Cheers,
Kevin
Kis János Tamás wrote:
Hi,
I have a big table with 21094 rows and each row has a geometry (polygon)
column with average more than 10 point.
When I run the next SQL:
UPDATE kecskemet_k.foldreszletek AS t SET hrsz=i.szoveg
FROM ( SELECT t.sorszam, f.szoveg
FROM kecskemet_k.foldreszletek t,
kecskemet_k.feliratok f
WHERE t.geometria && f.geometria
AND intersects( t.geometria, f.geometria )
AND f.reteg IN ( '11' )
) AS i
WHERE t.sorszam=i.sorszam;
I get the next message:
ERROR: out of memory
DETAIL: Failed on request of size 2941.
********** Error **********
ERROR: out of memory
SQL state: 53200
Detail: Failed on request of size 2941.
And now What can I do...? Where is the problem? Where I need to search?
Thanks,
kjt
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
