[postgis-users] out of memory @ UPDATE a big table

[Kevin Neufeld]

:) 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users