How slow is too slow when using ArcGIS Enterprise with a PostgreSQL backend?

[JonJones1]

Hey everyone,

Quick question — how slow is too slow when using ArcGIS Enterprise with a PostgreSQL backend?

Here’s what I’ve got going on:

I’m referencing my data directly from a PostgreSQL database — I’m not copying it to the ArcGIS Data Store. I’ve uploaded a short video below to show what I mean. The feature class shown is only 68 MB, so it’s not huge by any means, but as you’ll see, performance feels pretty sluggish.

Also, for context:

• I’ll include full specs of our Enterprise environment (Portal, Server, PostgreSQL, etc.)

• I’ll also include the specs of my local machine, just in case the issue is on my end

It’s not just the portal either. Even inside ArcGIS Pro, using a direct .sde connection to that same PostgreSQL server, everything feels painfully slow. Just as an example:

I deleted a 6 KB table from within Pro that was stored in the PostgreSQL server, and it took three and a half minutes to complete. 😬

So yeah — just wondering, is this normal? Or should I start digging into tuning or configuration changes?
I have attached a video of me using the portal with the above described feature class being on the PostgreSQL server.

Thanks a ton in advance for any insights!

Finally,  this is a brand-new Enterprise setup with a fresh PostgreSQL server, it’s the only workload on that box, and I’m the only user connected right now. I'm all alone and so is it, and this is the speeds I get. 

Also my ping speed to the server:

[George_Thompson]

If you are connecting to the PostgreSQL instance in Azure from your local machine you may experience some latency with the data. We highly recommend that you have the Pro client in the same VNet as the PostgreSQL instance for best performance.

Is the PostgreSQL an enterprise geodatabase or just a PostgreSQL database?

From the video it looks like you are experiencing the issue when connecting to a service that is published to Enterprise, correct?

Can you also provide the versions of Enterprise / Pro installed?

Are they fully patched?

[MarcoBoeringa]

Those ping latencies do not look to good, although expected across larger distances with machines in different regions. My local network setup, which is of course not comparable as being best case, has <1ms latency on ping to my VM running PostgreSQL.

I think this explains a lot of your issue, and George's comment about running ArcGIS Enterprise and Pro on the same VNet as PostgreSQL:

https://innerjoin.bit.io/the-distance-dilemma-measuring-and-mitigating-postgres-network-latency-76f6...