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

[Kis János Tamás]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080613/e81fc63d/attachment.html>