Skip to main content
  • EN

Hello,

In some cases I get out of memory exception when using writers. The reason is that FME needs to get all results for example from postgis into memory and then save it (for example in GML or DWG format).

When there is a lot of data then problem appears.

 

One soluton for that would be to use paging.

First execute count() query to check how many records are we expecting and then for each part run workspacerunner with some limit and offset parameters.

 

That works nice but:

In my case I need to first take a polygon by which I will do filtering and then take all rows from another table that intersects with this polygon.

Using FME Reader with intersects in works quite well but when I want to execute that query on my postgres DB then it takes forever even though I have geo indexes set on both tables :/

 

Do you have any experiences with such a problem?

 

 

Hi @witos,

 

Just want to confirm, are you using a 64 bit installation or FME? Additionally have you tried adjusting the Number of Records To Fetch At a Time parameter to a lower number in the PostGIS reader parameters under the Advanced section?

Additionally, there are tips for Adjusting Memory Resources in the documentation that might also be helpful for this.

Reply


Community Stats

30,109
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.