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

[yockee]

Hi @VinceAngelo  , here is what the database version says : PostgreSQL 16.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.4.1 20231218 (Red Hat 11.4.1-3), 64-bit . I am running Arcgis enterprise 11.0.

[VinceAngelo]

That's not a supported combination.  It might work, or it might spawn a small black hole which consumes the data center. I wouldn't hold my breath for either of these outcomes for ArcGIS 11.0.

- V

[yockee]

How about the memory and all the settings, regardless the versions difference ? Please help to poin to any articles.. thank you.  @VinceAngelo