topic Re: "Feature Class Location" option on Enterprise Geodatabase very slow in ArcGIS Pro Questions

"Feature Class Location" option on Enterprise Geodatabase very slow

RenatoTeixeira1 — Mon, 17 Jan 2022 23:29:30 GMT

Hello,

I have a problem on Enterprise Geodatabase PostgreSQL 9.4 when I use some geoprocessing tools when select "Feature Class Location" is veryyy slow to select feature dataset, around 2 hours to select.

I clear metadata history as some people tell but nothing. My server is windows 2016 on Azure.

When I select a tinny feature dataset is ok, but when I choose a feature dataset with 10 huge feature classes, is toooo slow. I don't know what I do to solve this problem. any help ?

Note that, when I use pgadmin to select data is everything ok, using ArcGIS PRO ou ArcCatalog no. very slow.

Re: "Feature Class Location" option on Enterprise Geodatabase very slow

Robert_LeClair — Wed, 19 Jan 2022 16:49:37 GMT

What release of ArcGIS Pro are you using? At ArcGIS 2.9, the following versions are supported - PostgreSQL 13.3 (64-bit), 12.7 (64-bit), 11.12 (64-bit) and 10.17 (64-bit). 9.4 is an old release of PostgreSQL. A couple things to try - have any database maintenance GP tools been run on the feature classes? If not, I would run Analyze, Analyze Datasets, Rebuild Indexes and if you're working with versioned data, the Compress GP tool. All these tools will optimize queries, selections and such.