Skip to main content
Question

How to optimise PostGIS DB Reader performance, currently I run out of memory.


Another learning FME question:

 

I have a postGIS table with 1.6million records.

I have 264 features from a lot of post process from another dataset.

 

Each 264 features have been split to 4 extent coordinates.

 

I need to understand the nearest neighbouring shape from the 1.6 million record PostGIS database (single table) for each 4 coordinates.

 

This means that FME Desktop attempts to cache the 1.6 million PostGIS records so it can then complete the nearest neighbour checks. I get 25% of the way through before I run out of memory and to be perfectly honest, I am slightly impressed my dinky laptop got this far.

 

How would I go about changing this flow to increase performance?

 

hj 

Many thanks

 

0 replies

Be the first to reply!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings