Postgresql configuration setting

yockee

I am about to embark on a survey project using Field Map. The data are stored on postgresql 16 using Enterprise 11.0.

What settings / configurations should I consider ? What values do I set into ?

The survey will involve:

- 70 surveyor using mobile phone accessing Field Map. Probably will have 20-30 concurrrent insert to database.

- point Feature Class that contain data to be inserted. There are around 30 cloumns to be filled in. This will contain some photos too, small size around 10 - 50 kb. Editing attributes will happen here, including insert photos (small size, 10-50kb).

- Polygon Feature Class that contain photos and 4 attributes only for confirmatory process. This will be used as guidance only, no editing here.

- QC processes using arcgis pro. this will access geodatabase directly and accessing survey data via feature service. This will compare the newly inserted data and the old data. There will be around 5 - 10 people doing the QC.

Here is the current configuration:

 

VinceAngelo

Your first step should be to search on "arcgis postgresql requirements" and look to see if the database is supported (PG 16 isn't supported at 11.4.0, much less 11.0).

I haven't tuned an RDBMS in at least a decade, possibly two, so I doubt this is a priority.

- V