[postgis-users] out of memory @ UPDATE a big table
Kis János Tamás
kjt at takarnet.hu
Wed Jun 18 05:13:06 PDT 2008
2008 18.31 dátummal Kevin Neufeld <kneufeld at refractions.net> ezt írta:
> 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
> 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.
Maybe I found what was the problem:
In the table is 21094 POLYGONs:
sum: ~280000 points,
avg: ~13 point/POLYGON,
sum area: ~32000 ha
avg area: ~1.5 ha
and I have a -I think- too big POLYGON (at PostGIS || at my
computer), wich has ~3000 points and ~3200 ha.
If it exists, then I get the out of memory error irrespectively of
postgresql.conf settings. But when I delete it from table, all right.
What can I do, if I don't want delete it?
McAfee SCM 4.1 által ellenőrizve!
More information about the postgis-users