Hello,
> 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.
thanks for that hint. In the XML files i have added:
<Parameter name="cursor_size">100</Parameter>
It seems that that query now takes forever. Maybe 100 is not the best choice?
Does anybody have a hint on what would be a reasonable value for cursor_size?
On the other hand, what amount of RAM would help in not needing to set
cursor_size? I have 8 Gb RAM at the moment, would an update to 16 Gb help?
Best regards,
Torsten.
_______________________________________________
Mapnik-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/mapnik-users
