Mapnik's postgis plugin has an option called 'cursor_size'.
It is default set to 0 which mean no cursors are used,
but it you set it to some value over 0 then results will be fetched in chunks.
Try that and let us know how it works for you.
Dane
On Oct 25, 2011, at 5:57 PM, Torsten Mohr wrote:
> Hello,
>
> i had PostGIS / Mapnik installed before and all was working fine.
>
> I just re-installed PostGIS / Mapnik-0.7.1 and calling a script that
> worked before gives me an out of memory error now:
>
> Traceback (most recent call last):
> File "./generate_image.py", line 91, in <module>
> render(m, im)
> RuntimeError: PSQL error:
> out of memory for query result
> Full sql was: 'SELECT AsBinary("way") AS
> geom,"amenity","landuse","leisure","military","name","natural","power","tourism"
>
> from (select * from planet_osm_polygon order by z_order,way_area desc) as
> leisure WHERE "way" && SetSRID('BOX3D(503843.2677405493
> 5749599.546361594,1833866.038918196 7522963.241265123)'::box3d, 900913)'
>
>
> I'm trying to generate a quite large image of whole Germany with the
> boundings:
> (10.0, 46, 11.0, 56)
>
> I try to generate it into a PNG of dimensions 6000 x 8000. I have 8 Gb of
> RAM.
>
> Is this error only due to the increase of input data? planet_osm*.tar.bz2
> size is nowadays 18 Gb, the one i used before was "only" 12 Gb?
>
> Is there a way to work around this? For example does Mapnik-2.0 fix this
> somehow?
>
> I guess creating the final image in tiles and then connecting them together
> will not give the same result, as text placement would be done completely
> different and would be just not done around the tile borders?
>
> Has anybody got a hint on how to proceed best?
>
>
> Best regards,
> Torsten.
> _______________________________________________
> Mapnik-users mailing list
> [email protected]
> https://lists.berlios.de/mailman/listinfo/mapnik-users
_______________________________________________
Mapnik-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/mapnik-users
