Hi everybody,
i have to import smal jpg-files (400-500 kb) with geometry into a postgis bytea column. the process is very slow. for example the time to import 40 images takes 10 minutes. the import with pglobeditor takes 2 seconds.
Please help what could be the cause.
,
Best answer by fmelizard
Slow writing of data as bytea with the PostGIS Writer is a known issue in FME. Development is working on improving it as PR# 57164.
+5Your process drops an existing table 'flug.images'... and creates table 'flug.images'...
Check this step:
From the screenshot, looks like you are using the PostGIS write. Have you tried the PostGIS Raster writer [POSTGIS_RASTER] ?
Your process drops an existing table 'flug.images'... and creates table 'flug.images'...
Check this step:
Now, i have killed the index. Drop and Creation was only in my demo. But there was no effect. have a look to the new logfile.
+18Slow writing of data as bytea with the PostGIS Writer is a known issue in FME. Development is working on improving it as PR# 57164.
Slow writing of data as bytea with the PostGIS Writer is a known issue in FME. Development is working on improving it as PR# 57164.
+16Slow writing of data as bytea with the PostGIS Writer is a known issue in FME. Development is working on improving it as PR# 57164.
+16
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
